Link to home
Start Free TrialLog in
Avatar of 0nepiece
0nepieceFlag for Philippines

asked on

How to set Textbox to accept only numeric inputs?

Hi Everyone,

  Is there a way for a textbox in Excel 2007 VBA that restricts the user to key in only numeric values? Like the property in VB .NET? TIA.
Avatar of Dave
Dave
Flag of Australia image

What sort of TextBox - a TextBox on an UserForm?

Cheers

Dave
Avatar of 0nepiece

ASKER

@Dave : Yes dave, used on a userform? umm, are there others besides having it in a userform?
SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for your inputs and I apologize for the delay. :D Ourjouwan's tip suits my need. Although all answers does help in having only numeric inputs. Thank you very much! :D