Only Numeric Value in Input Box?

**erock24** · 11-20-2007, 02:14 PM

How can I edit the following code so that the user can only enter a numeric value in the input box? If it is not completely numeric I would like the user to know it has to be numeric and to try again. Everything else is exactly how I need it.
Thank you very much for your time and help.

Please Login or Register  to view this content.

**VBA Noob** · 11-20-2007, 02:16 PM

Need to use

Please Login or Register  to view this content.

. Link explains more

http://www.ozgrid.com/VBA/inputbox.htm

VBA Noob

**erock24** · 11-20-2007, 03:55 PM

I changed the code to reflect the "application.inputbox", and now when a user enters text the macro exits the sub, which is better, but I need it to say enter number, and let user try again???
any ideas?
Thank you for your time and help.

Please Login or Register  to view this content.

**VBA Noob** · 11-20-2007, 04:00 PM

Did you read the link.

You can define what is allowed out of the following. The below example is set up to accept numbers

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

**erock24** · 11-20-2007, 05:23 PM

thank you for the clarification:

This did the trick:

Please Login or Register  to view this content.

**VBA Noob** · 11-20-2007, 05:24 PM

No problem

VBA Noob

Only Numeric Value in Input Box?

LinkBack

Thread Tools

Rate This Thread

Display

Only Numeric Value in Input Box?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions