LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to accept input and then populate/concatenate this with other Pank New Users to Excel 4 February 27th 07 03:38 PM
accept input and move active cell? JR Hester Excel Programming 4 July 28th 06 04:43 PM
Can a cell be set to accept input only once? Simple Gifts Excel Worksheet Functions 1 April 4th 06 05:08 AM
I want to maintain a master listing and accept input and output? shital shah Excel Programming 2 March 7th 05 07:15 AM
Can VBA accept input from a message box? dougmcc1[_7_] Excel Programming 1 October 7th 04 10:48 PM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"