validation of input in textbox
 

I can't find how to validate the input of a textbox.
I want an errormessage to appear when the user leaves the textbo
empty. How do I do this?

Thanks in advance.

P.S.
I'm extremely new at VBA, so please forgive me any stupid questions

--
Message posted from http://www.ExcelForum.com

validation of input in textbox
 

There is no built in support for validating a textbox.

You would need to write code to run at the appropriate time to check whether
the textbox is empty or not.

Since you have shared nothing about whether the textbox is from the forms
toolbar or from the control toolbox toolbar or where it is located or when
it is to be validated, or what actions you want to take if the textbox is
found empty, there is little help that can be offered.

--
Regards,
Tom Ogilvy

"Peer " wrote in message
...
I can't find how to validate the input of a textbox.
I want an errormessage to appear when the user leaves the textbox
empty. How do I do this?

Thanks in advance.

P.S.
I'm extremely new at VBA, so please forgive me any stupid questions.


---
Message posted from http://www.ExcelForum.com/

validation of input in textbox
 

Go to the Data menu and click on validation.

validation of input in textbox
 

Which doesn't work with a textbox, only cells.

--
Regards,
Tom Ogilvy

"Lee" wrote in message
om...
Go to the Data menu and click on validation.