Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting validation to TextBox in the userform
hello guys
i use userform to autofilter the data from the list. when i put th username it just filters the usernames details. Question: does anyone know how to put validation to textbox. eg just letters. i end-user puts number, i want system to show an error message. and also if the text that will be put in textbox does not exist i (data,list)i want system to show error messege. if you can help i will appriciate guys thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting validation to TextBox in the userform
I think this is along the right lines...
Private Sub textbox1_KeyPress(ByVal KeyAscii As _ MSForms.ReturnInteger) If Not IsNumeric(Chr(KeyAscii)) Then msgbox "Please only use numbers" KeyAscii = 0 End If End Sub Hope it is of some use -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform textbox | Excel Worksheet Functions | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Help with Syntax UserForm TextBox | Excel Programming | |||
Userform Textbox in Password Validation | Excel Programming | |||
Populating Textbox in UserForm | Excel Programming |