RTR97
08-07-2012, 12:51 PM
Hello All,
I have working code to check a textbox for null values, etc. however I am not certain how to implement this code for let's say 5 textboxes. Any advice will be greatly appreciated.
Private Sub CommandButton1_Click()
If Trim(textBox1 & "") = vbNullString Then
MsgBox "Please Enter a numerical value in textBox1"
Else
Range("myCell") = ">" & Me.textBox1.Value
End If
End Sub
I have working code to check a textbox for null values, etc. however I am not certain how to implement this code for let's say 5 textboxes. Any advice will be greatly appreciated.
Private Sub CommandButton1_Click()
If Trim(textBox1 & "") = vbNullString Then
MsgBox "Please Enter a numerical value in textBox1"
Else
Range("myCell") = ">" & Me.textBox1.Value
End If
End Sub