Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

What's the best way to determine whether input is numeric?

I'm working on a spreadsheet and when a quantity is entered I want to grab the data however, I want to ignore anything other than numeric input. What's the best way to determine whether input is numeric?
0
LorangerG
Asked:
LorangerG
1 Solution
 
Timbo87Commented:
If Not IsNumeric(thenumber) Then MsgBox "Error, not numeric."
0
 
LorangerGAuthor Commented:
Thanks Tim. I appreciate the help!!!
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now