| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
Thanks for that it works great
Greg "Greg" wrote in message ... Thanks for that Chip will try Greg "Chip Pearson" wrote in message ... The following code will loop until the user enters a number greater than 10. Note that the code uses Excel's InputBox method, not the standard VBA InputBox function. The 'Application.' is required. Dim D As Double Do Until D 10 D = Application.InputBox(prompt:="Enter a number.", Type:=1) Loop -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Greg" wrote in message ... Sorry just to add to that if the answer is not right can it be looped back to the inputbox again Thanks Greg "Greg" wrote in message ... Hi all, Just wondering how I can have the following code to check if the answer is only in numeric form? dim Checker checker = inputbox("What is the player's registration number?") Thanks in advance Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding 10 smallest numbers from last 20 input | Excel Worksheet Functions | |||
| How do I update a spreadsheet with numbers input into another? | New Users to Excel | |||
| numbers are changes when input | Excel Discussion (Misc queries) | |||
| Sum of Numbers Smaller than input | Excel Discussion (Misc queries) | |||
| Sum of Numbers Smaller than input | Excel Discussion (Misc queries) | |||
![Greg[_35_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
