Make Caption Flash in the command button in Userform

[eddyrcabrera79]

In my Userform I have a command button with the Caption “Email Form Back”.

How can I make this Caption blink in different colors? I just need the letters to blink not the command button background as it setup as transparent. it is meant to grab user's attention

If I need to update my current code, could you please let me know where I should put it?

Attached is a sample of my excel document

Thank you

 

[chirayu]

Problem is that trying to get it to flash constantly would require an Application.OnTime loop. Which basically would change its colour every second. Now as this is a loop - it means that this macro would keep working constantly & hinder the use of other parts.

Heres some links to help with the OnTime part (probably more on google)
http://www.cpearson.com/excel/OnTime.aspx
http://www.snb-vba.eu/VBA_Application.OnTime_en.html
https://msdn.microsoft.com/en-us/library/office/ff196165.aspx

 

[eddyrcabrera79]

what about making the button blink, is that complicated?

 

[chirayu]

Same thing. Essentially you're getting it to either turn off & on/ change colour in a loop. Easier to just change the font type/size for the button & keep it in a different colour from the start

Found a workaround. Make an animated GIF & use the webrowser control tom load it into the form. base your code onto that.

http://stackoverflow.com/questions/21859096/can-i-how-do-i-show-a-webpage-in-an-excel-form

 

[eddyrcabrera79]

Thank you so much