AAARRRGGGHHH

[jimmy]

I have protected my sheet so all the data entry user has
to do is hit the <TAB> key to move to the next cell
requiring data. I have exhausted all my ideas using DATA
VALIDATION to not allow a blank cell. (I did uncheck the
IGNORE BLANK box)

I want Excel to pop up an error message and prevent the
user from continuing to the next cell until data is
entered in the cell they're on.

Any ideas?

Thanx in advance - jimmy

 

[Frank Kabel]

Hi
not possible without using VBA (an event procedure. e.g.
worksheet_selectionchange). See:
http://www.cpearson.com/excel/events.htm

 

[jimmy]

THANK YOU VERY MUCH Frank - jimmy

-----Original Message-----
Hi
not possible without using VBA (an event procedure. e.g.
worksheet_selectionchange). See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany



.