VBA Script

[Raja Kamarthi]

Hello Friends,


Is there a script to set a "Combo Box" in a blinking mode?

I'm aware of the VBA (below) to set a cell in a blinking mode

Sub Auto_open()

With ThisWorkbook.Worksheets("Hiring Dashboard").Range("A1").Font

If .ColorIndex = 3 Then ' Red Text

.ColorIndex = 2 ' White Text

Else

.ColorIndex = 3 ' Red Text

End If

End With

RunWhen = Now + TimeSerial(0, 0, 1)

Application.OnTime RunWhen, "'" & ThisWorkbook.Name & "'!Auto_open", , True

End Sub


but not sure if the same can be tried on a "Combo Box".


Please share your thoughts.


Thanks,

Raja Kamarthi

 

[SirJB7]

Hi, Raja Kamarthi!


Better later than never, isn't it?

I'm afraid that your example doesn't set a cell to "blinking" mode, it just changes it font color on a timed basis.


I haven't ever tried to do such a thing but:


1) controls in worksheets

a) ActiveX combo box has a ForeColor property

b) form control combo box hasn't such a property

So it'd be probable that with the first type of controls you might be able to emulate your so called "blinking", just give a try. But surely not with the second ones.


2) controls in user forms

Same as 1) a) only.


Regards!

 

[Luke M]

A friendly warning, blinking text, expescially red blinking text, can cause seizures for people who have epilepsy. =(

 

[SirJB7]

@Luke M

Hi!

And additional effects...

In my case I got very thirsty and nothing but a six-pack of Carslberg could help me.

Regards!

 

[bobhc]

Good day SirJB7


Six pack.....I see you have reduced your Carslberg intake

 

[SirJB7]

@b(ut)ob(ut)hc

Hi, old dog fully new tricked!

Good afternoon for you to, my dear friend.

It's because of the advice of one of my advisors board's subcommittee... that integrated by my tailors and my accountants... originally there were three groups of members but I decided to exclude my doctors from it as I never received a positive advice from it... should I now exclude any other group or directly disband the subcommittee?

Regards!

PS: this started when another subcommittee, that which deals with the production of signal intelligence information (a personal and little NSA), began to alert about my tailors excessive enrichment primarily because of my account.