Z
Zaid Qureshi
(1) Use VBA code to restrict the input to numbers like so:
(assuming that the textbox is called textbox1)
if Not IsNumeric(Textbox1.Text) then
msgbox "You must only enter numbers"
TextBox1.Text = Empty
End if
(2) Set the MaxLength property of the textbox to 4 to
restrict the length to a 4 character input.
Zaid Qureshi
(assuming that the textbox is called textbox1)
if Not IsNumeric(Textbox1.Text) then
msgbox "You must only enter numbers"
TextBox1.Text = Empty
End if
(2) Set the MaxLength property of the textbox to 4 to
restrict the length to a 4 character input.
Zaid Qureshi