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"?

Thanks


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

Thanks

Thanks