Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
you could try the inputbox method (versus inputbox function). it will
restrict the input to numbers, but you still have to check to see if they canceled the inputbox. Sub test() Dim checker As Long checker = Clng(Application.InputBox("What is the player's registration number?", Type:=1)) If checker = 0 Then Exit Sub End Sub "Greg" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers Only in input box
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 |
#6
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 |
Reply |
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) |