DarrenJackson
asked on
VB Script to check if textbox is blank
Guys
I need an example of a vb script for excel 2003 that checks a textbox to see if it is blank if it is it then prompts you to enter a value in the text box but if there is a value there then do nothing
Any ideas
Regards
I need an example of a vb script for excel 2003 that checks a textbox to see if it is blank if it is it then prompts you to enter a value in the text box but if there is a value there then do nothing
Any ideas
Regards
ASKER
Sorry when the excel sheet is opened
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Guys
Thanks for the code I have just tried Chris's and they all work as desired
Thanks I will split points
Thankyou
Thanks for the code I have just tried Chris's and they all work as desired
Thanks I will split points
Thankyou
ASKER
Great Thanks
Can you be more specific about the process, what event will "trigger" the check?
Thanks
Dave