MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Userform textbox - only numbers

Posted by Ben on April 28, 2001 6:20 AM

Is it possible to have a userform textbox that only allows a number to be entered and/or displays a error message that says "Sorry only number can be entered for price"?


Posted by Patrick on April 28, 2001 6:56 AM

Private Sub TextBox1_Change()
Selection.NumberFormat = "0.00"
MsgBox "Must be a number."
End Sub

My guess!!

Posted by Ben on April 28, 2001 7:07 AM