Flashing commandbutton...

[1Big_Daddy]

Is it possible to write code that would make a commandbutton flash to draw the user's attention?

 

[BrianB]

Try this. If you want delays of less than 1 second have a look at the API Sleep function.

Sub Flashy()
    With ActiveSheet.CommandButton1
        For n = 1 To 5
            .BackColor = &HC0C0FF               'pink
            DoEvents
            Application.Wait Now + TimeValue("00:00:01") ' 1 second
            .BackColor = &HC0C0C0               'grey
            DoEvents
            Application.Wait Now + TimeValue("00:00:01") ' 1 second
        Next
    End With
End Sub

 

[1Big_Daddy]

Excellent suggestion Brian!! It works great!!! Thank you.

 

[Ark68]

Resurrecting this post ...
This is a great start to what I'm looking for. Is anyone able to modify this to best go about having this commandbutton (on my userform) continue to blink until it's pressed?

 

[Joe4]

You may want to re-think that. That sort of thing can cause seizures in people who suffer form epilepsy.
Some places even have laws regarding this.

See: https://www.epilepsy.org.uk/info/photosensitive-epilepsy/web-design

 

[Ark68]

For my own personal use I don't think I need to worry about that, but thank you for your concern.

 

[dmt32]

Hi Joe4,
Just curious – this is a very old thread – as a MOD are you aware of any forum rule about thread “hijacking”? Not suggesting OP has done anything wrong just wondering how MrExcel views such activity?

Dave

 

[Joe4]

The forum rules can be found here: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
See rule #9 for the best way of handling these type of concerns.

I would not call this thread hijacking for two reasons:
- The thread has been dormant for 10 years
- The question was directly related to the replies

Thread hijacking is more commonly defined when someone posts their own question to an active thread, and the question quite often is very different from the question being asked.

That being said, I would recommend users post their questions to new threads instead of posting to old threads for the following reasons.
- Since the question already has replies, it will not show up on the "Zero Reply Posts" listing that many people go to in order to look for new unanswered questions, so it will get passed over by many potential helpers.
- Sometimes the users involved in the original thread are not that active on the forum anymore, so they might not see the question.

My recommendation would be to start a new thread, and include a link to this other thread, if it is helpful in explaining your issue. However, you typically only want to post the question once, as we do have rules against duplicate postings! So you need to pick one or the other.

 

[dmt32]

Hi,
I had a feeling that you would point out rule 9 but as said, did not think OP was doing anything wrong and also, going rule 9 route, others would not see the response which they may find useful.

I know another forums get quite animated with members stepping in to another’s thread but MrExcel (thankfully) less so but there does not seem to be much guidance in this area perhaps your very helpful response could be added to posting notes?

Many Thanks.

Dave

 

[De Bruce]

Try this. If you want delays of less than 1 second have a look at the API Sleep function.

Sub Flashy()
    With ActiveSheet.CommandButton1
        For n = 1 To 5
            .BackColor = &HC0C0FF               'pink
            DoEvents
            Application.Wait Now + TimeValue("00:00:01") ' 1 second
            .BackColor = &HC0C0C0               'grey
            DoEvents
            Application.Wait Now + TimeValue("00:00:01") ' 1 second
        Next
    End With
End Sub

Please, how can I achieve this on a userform with command button I want to blink.