Is there a validation method for user form textbox ?

[OscarPCG]

Is there a validation method for user form textbox?
I would like to restrict data entered into a text box to numbers or letters only (depending on the textbox)?

Thanks
Oscar

 

[ribhead]

Oscar,
I'm not an MVP but couln't you use a
Private Sub Txtbox3 After_Update
Loop until ISNUMERIC(Txtbox3.Value)=True
MsgBox "Enter a number dumby!",Vbokonly,"Stupid Person"
Txtbox3.Value=""
Cancel=True
Txtbox3.SetFocus
Do
End Sub

Just a thought
One of the MVPs probably have a better idea.

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[TonyJollans]

Hi Oscar,

There is no built in validation but there are several events where you can code your own - BeforeUpdate is the usual event for validation.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[PHV]

Generally the validation rules are enforced in the BeforeUpdate event procedure of the control, so you can play with the Cancel variable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[OscarPCG]

Thanks guys! This is exactly what I was looking for.

Oscar

 

[taupirho]

Check out my FAQ:- faq707-5194