Hi guys,

This should be straighforward, but I can't figure out. Please help:

I have created a text box that when clicked on runs a macro. So
currently:

1. User clicks on the TextBox
2. Specified Macro is run

and I want:

1. User clicks on the TextBox
2. Excel checks if at least one of the 3 cells (A1, A2, A3) has a value
in it
if Yes then it runs the Macro as planned
if Not then it brings up an error message asking the user to enter a
value in any of the cells (A1, A2 or A3).

Thanks for your help


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=399042