HiI
I am using the below code attached to a camand button on an excel 2007 userform
I wanted only whole number to be excepted, but this code will allow the + or - sign at the end of the number. How can I correct this?
If IsNumeric(Me.txtbox1.Value) Then
ws.Cells(iRow, 1).Value = Me.txtbox1.Value
Else
MsgBox "Please enter a numeric value"
Me.txtbox1.Value = ""
Me.txtbox1SetFocus
Exit Sub
Thanks
L
I am using the below code attached to a camand button on an excel 2007 userform
I wanted only whole number to be excepted, but this code will allow the + or - sign at the end of the number. How can I correct this?
If IsNumeric(Me.txtbox1.Value) Then
ws.Cells(iRow, 1).Value = Me.txtbox1.Value
Else
MsgBox "Please enter a numeric value"
Me.txtbox1.Value = ""
Me.txtbox1SetFocus
Exit Sub
Thanks
L