Hi

I am trying to do a data validation of some sort in a textbox and wondering if it is possible. I was hoping to restrict the input to 4 digits, no more no less! If there is anyone who can help please let me know! Here is part of my code if that helps explain what is happening!

Private Sub btnSearchMachNum_Click()
 Dim number As String
Prompt = "Please enter the number using 4 digits." & vbNewLine & "(i.e. 300 should be '0300')" & vbNewLine & Path
 Title = "Input Number"
 macnumber = InputBox(Prompt, Title, "Enter search term")
Call FindAll(macnumber, True)
 End Sub
--Leah