I'd like to cause the background in the excel window to flash when a
particular event happens. I'm really new when it comes to VBA programming and
a total self-taught novice. I think I need to somehow change the
vbWindowBackground but I'm not sure a) if that is correct and b) how to go
about doing that. Here's the basic problem: I wrote a small app that displays
a form and allows a user to enter a number in a text box an have the form
display a countdown based on the number entered. I want to "flash" the
background a few times at particular intervals and then again at the end of
the timer (sort of silent alarms). I have my code setup to trip boolean
variables at the intervals and test against the variables to see if the
variable is currently true... when true... do something when not... do
nothing... the problem is I don't know how to tell it to change the
background color on the window (the worksheet is minimized so all the user
sees is the blue background of the window. Can this be done? If so, how?
Ideally i'd like to flash it red and then return to the default blue. Your
help is greatly appreciated! Thanks!

This should get you started:
http://en.allexperts.com/q/Excel-105...ng-results.htm

http://www.mrexcel.com/archive/VBA/5889.html

http://www.cpearson.com/excel/BlinkingText.aspx


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ArielZusya" wrote:

I'd like to cause the background in the excel window to flash when a
particular event happens. I'm really new when it comes to VBA programming and
a total self-taught novice. I think I need to somehow change the
vbWindowBackground but I'm not sure a) if that is correct and b) how to go
about doing that. Here's the basic problem: I wrote a small app that displays
a form and allows a user to enter a number in a text box an have the form
display a countdown based on the number entered. I want to "flash" the
background a few times at particular intervals and then again at the end of
the timer (sort of silent alarms). I have my code setup to trip boolean
variables at the intervals and test against the variables to see if the
variable is currently true... when true... do something when not... do
nothing... the problem is I don't know how to tell it to change the
background color on the window (the worksheet is minimized so all the user
sees is the blue background of the window. Can this be done? If so, how?
Ideally i'd like to flash it red and then return to the default blue. Your
help is greatly appreciated! Thanks!

Hi Ryan,

Thanks for your response. I'm actually not looking for information on
blinking the background of a cell or the text within the cell. I'm actually
looking for information on blinking or flashing the background of the window
while the spreadsheet is minimized within. Any idea how to do that? I thought
it might have something to do with vbWindowBackground but I'm not sure. Any
help would be appreciated. Thanks!

-A

"ryguy7272" wrote:

This should get you started:
http://en.allexperts.com/q/Excel-105...ng-results.htm

http://www.mrexcel.com/archive/VBA/5889.html

http://www.cpearson.com/excel/BlinkingText.aspx


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ArielZusya" wrote:

I'd like to cause the background in the excel window to flash when a
particular event happens. I'm really new when it comes to VBA programming and
a total self-taught novice. I think I need to somehow change the
vbWindowBackground but I'm not sure a) if that is correct and b) how to go
about doing that. Here's the basic problem: I wrote a small app that displays
a form and allows a user to enter a number in a text box an have the form
display a countdown based on the number entered. I want to "flash" the
background a few times at particular intervals and then again at the end of
the timer (sort of silent alarms). I have my code setup to trip boolean
variables at the intervals and test against the variables to see if the
variable is currently true... when true... do something when not... do
nothing... the problem is I don't know how to tell it to change the
background color on the window (the worksheet is minimized so all the user
sees is the blue background of the window. Can this be done? If so, how?
Ideally i'd like to flash it red and then return to the default blue. Your
help is greatly appreciated! Thanks!