User proofing an entry

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

hi,
If they are missing them now, i doubt that flashing cells will make much
difference.
The key here is to STOP the upload to the other system WITH empty cells.
I would suggest that you look at this event and add some code like this at
the very begining. this way if they fail to enter data into the required
cells, they get a message reminder and code STOPS BEFORE the upload untill
they do enter the required data.

If IsEmpty(Range("K2")) Then
MsgBox ("Input something in to k2")
Exit Sub
Else
If IsEmpty(Range("L2")) Then
MsgBox ("Input something in to L2")
Exit Sub
Else
If IsEmpty(Range("M2")) Then
MsgBox ("Input something in to M2")
Exit Sub
End If
End If
End If

just an idea. adjust the code to fit your data.

Regards
FSt1

"L.White" wrote:

> 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
>
>
>