Fireworks explosion ends with a text message

[kaushik03]

Dear All,

I was looking at Chandoo's fireworks explosion workbook and was trying to customize it.

http://chandoo.org/wp/2014/07/17/fireworks-chart-video-tutorial/

What I am trying to achieve is to have a short text message (let's say : crossed X Million etc.) appear at the end of each random fireworks explosion, and the message should stay for at least 2-3 seconds (for readers to read the message) before the next fireworks starts.

Hope I am clear about my requirement.

I have uploaded Chandoo's workbook.

Hope to get a solution from you.
Regards,
Kaushik

 

[PCosta87]

Dear All,

I was looking at Chandoo's fireworks explosion workbook and was trying to customize it.

http://chandoo.org/wp/2014/07/17/fireworks-chart-video-tutorial/

What I am trying to achieve is to have a short text message (let's say : crossed X Million etc.) appear at the end of each random fireworks explosion, and the message should stay for at least 2-3 seconds (for readers to read the message) before the next fireworks starts.

Hope I am clear about my requirement.

I have uploaded Chandoo's workbook.

Hope to get a solution from you.
Regards,
Kaushik

Hi,

Please refer to attachment

You can now create more messages (for each cracker) and have VBA display them after each explosion.

Hope this is what you were looking for.

 

[kaushik03]

Dear PCosta,

Truly appreciate your time and effort in helping me on this.

Please note that, the position of the message should not be static. It should be in accordance with the position of fireworks explosion (on the tip of the fireworks). Essentially, the co-ordinates of the message should change as per the fireworks explosion. Please see the attachment.

Please let me know if you find any workaround for the same.

Looking forward to haring from you.

Regards,
Kaushik

 

[PCosta87]

Dear PCosta,

Truly appreciate your time and effort in helping me on this.

Please note that, the position of the message should not be static. It should be in accordance with the position of fireworks explosion (on the tip of the fireworks). Essentially, the co-ordinates of the message should change as per the fireworks explosion. Please see the attachment.

Please let me know if you find any workaround for the same.

Looking forward to haring from you.

Regards,
Kaushik

Hi,

Hope you had a great weekend

Please refer to attachment.
Messages now account for the position of the cracker.
Let me know if there is anything else I can help with