form validation

slim · Feb 25th, 2002, 02:45 AM

Ok second question of the day.

Can someone tell me the code I need to validate form entry.
I want a message box to appear if someone attempts to submit details(by clicking a button) if they have left a textbox empty (or put the wrong info in).

Thanks
Andy

Mudface · Feb 25th, 2002, 03:40 AM

There's many ways to do this. As a starter you might try stuff like: -

If TextBox1.Text = "" Then MsgBox ....

If Not IsNumeric(TextBox1.Text) Then MsgBox ...

MaxValue = 1000 ' As an example
If TextBox1.Text > MaxValue Then MsgBox ...

Note you can also restrict what people can actually type into a textbox in the first place with the TextBox_Change() Event.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 02:45 AM	#1
slim New Member Join Date: Feb 2002 Posts: 42	Ok second question of the day. Can someone tell me the code I need to validate form entry. I want a message box to appear if someone attempts to submit details(by clicking a button) if they have left a textbox empty (or put the wrong info in). Thanks Andy

Feb 25th, 2002, 03:40 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	There's many ways to do this. As a starter you might try stuff like: - If TextBox1.Text = "" Then MsgBox .... If Not IsNumeric(TextBox1.Text) Then MsgBox ... MaxValue = 1000 ' As an example If TextBox1.Text > MaxValue Then MsgBox ... Note you can also restrict what people can actually type into a textbox in the first place with the TextBox_Change() Event.