Make flashing text 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.

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

[JBeaucaire]

The Changing of a cell or userform field to an unexpected color like red or orange while using the workbook is common and politely indicates to the user attention is needed.

However, going even further and using blinking flashing text or colors is, and always will be, in my opinion, rude and demeaning to the user.

Case in point:

1) Please enter the last name (simple, seems possibly optional)

1) Please enter the last name (clearly not optional any longer)

1) Please enter the last name! (clearly not optional any longer, and sounds angry)

1) Please enter the last name!!! (clearly not optional any longer, and sounds angry and clearly the designer of the sheet now is talking down to me like I'm a child)



Multiple exclamation points have the exact same effect on me as flashing buttons... they seem to imply I'm a complete idiot, too dumb to actually know when a button or field highlights in red it needs attention.

So my first, best suggestion to you on this would be:

1) Change the text or button to red
2) Change it back when the issue is resolved
2) Disable the other fields if you really want that field handled immediately and want to control every moment of the user's use of your form

[eddyrcabrera79]

Hi JBeaucaire

I understand your point, but the only purpose is for all the required information to be filled and hightligt the send email option. the feeling of making people feel idiot or dumb is not the idea of this task, it is just for notification or grab the user's attention because the command button background is set as transparent.

Thanks

[JBeaucaire]

Having built numerous such userforms, I confirm my earlier assertion with this suggestion.

1) Disable the SEND EMAIL button so it is visible but unclickable

2) Have a userform_change event that is watching ALL the required fields and only enable the SEND EMAIL button when all required fields are filled in. This is common practice and intuitive, so not being a let to click the SEND EMAIL button should be all the plumbing needed.

[Marc L]

See here …