View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] audreyanderson1@gmail.com is offline
external usenet poster
 
Posts: 3
Default Need Input Box to only Accept Numeric Values

Help! I need a way to only allow numeric values to be accepted by an
input box. My code starts with


inputNum = InputBox("Please enter the part number", "Part Number",
0)
x = Val(inputNum)


I'm using a vlookup to make sure a input number is valid, but not sure
how to go about it if letters were input. The program should not go
any further if an alpha string is entered. How do I check for this??

Thank you!