Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
I have a sheet that is being used as a data gathering template. The users fill in as much available information here as they have and then through VBa we automate data entry into another system. However I have three cells that must be filled in for this to work. Currently those three cells are at the top middle of the opening view with a bright red background. Everyone has been trained to fill them out and they are still being missed. I want to make the background color flash until a value is entered into it. Does anyone know how to do this? Say, the background color changes from yellow to red every two seconds until any value other than blank is entered? LWhite |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ç(User Entry)è can any one explain this | Excel Discussion (Misc queries) | |||
I want to checkoff items as I'm proofing them | Excel Discussion (Misc queries) | |||
Tamper proofing | Excel Discussion (Misc queries) | |||
Msg Box - User Entry Validation | Excel Programming | |||
Error proofing automatic updating a cell | Excel Programming |