Flashing text in a text Box

I want a text in a textbook to be flashing. I figured out that it works better by making the textbox background color change.

Tried the follwoing code : (be advised, this flashing is a part of a larger macro that calculates the gear forces. I wanted the program to flash the contents of the textbox at the end . Hence I inseretd the following twoards the end of my code

HTML Code: 

Result :

• Didnt work or produce the anticipated results
  
• I tried something in the lines of whats explained on link http://www.vbforums.com/showthread.p...-in-two-colors
  
• But cant use it as it has a dedicated code starting
  HTML Code: 

• My case, the program does other calculations and towards the end highlights some important text in the toolboxes

Originally Posted by Ron Coderre

See if Chip Pearson's website helps:
http://www.cpearson.com/excel/BlinkingText.aspx

Hello, Thanks for getting back... I browsed thru and saw that its for a Cell Range in a worksheet. However, in my prgram, non of the values are copied onto any worksheet.

I am wanting to highlight a textbox in a userform.

Thanks,

Subbby

used time controls in VBA

Sorry, but you haven't. A Timer control in Classic VB is a control (much like a TextBox) added to a form. It has an 'Interval' property which runs code in the Event Handler for the control every time it fires.

In VBA there is a Timer object, not the same thing. You can store the value of the Timer and, later, compare with the current Timer value to see how long a procedure took to run, but there in no 'repeat' facility for the Timer Object - you have to use the OnTime statement to run a procedure at a particular time and then set another OnTime in that procedure to run again...

Splitting hairs, perhaps, but the Timer control would be very useful in VBA.

so its not possible ,what I am asking for ?

I didn't say it couldn't be done, just that it couldn't be done using a Timer control as you mentioned.

VBA has the OnTime Method. This sets up a procedure to run at a particular time. The problem is it's a one-off. To repeat the procedure you have to set another OnTime in the procedure for it to run again.

So, you could set up a procedure to change the textbox to White on Red. In that procedure you check the current Fore/Back colours and flip them. If the back color is currently Red then set to White (or whatever the standard background coloiur is), if White then set to Red. Same for the forecolor property.

It's messy, awkward to use and not very good. You need to cancel any pending OnTime statements at some stage as Excel will 'remember' it has to run a procedure even if you unload the workbook - If you have, the workbook will be loaded again so you have to store the next time the procedure is to run and use that to cancel it.

See this page for some more details but you are better off forgetting about flashing the textbox contents, in my opinion.