I'm sure what you ask is possible via VBA code. However, I would
question the logic behind such a move. First, that type of 'pop-up'
box is extremely annoying (ranks up there with flashing cells).
Second, it would not take long to figure out that all I would need to
do is erase the cell contents in the formula bar via backspace, simply
press the space bar then enter or just enter another value in the cell
to bypass the pop-up. Finally, there is the question of would you
apply this pop-up to a single cell only or to any selected range,
regardless of size?

Are you sure this is the route you want to go?

p.s. This forum is fine for this posting.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=476187