Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputbox
Hi Im using
Dim appliances as integer appsagain: appliances = InputBox(Prompt:="Appliances.", _ Title:="Sheet" & a, Default:="0") If appliances < 0 Then MsgBox ("Number to small") GoTo appsagain ElseIf appliances 40 Then MsgBox ("Number 40") GoTo appsagain End If What I want to do is if text is used in the input box then restart. At the momment if text is enetered then the code crashes. Any ideas. Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
inputbox | Excel Discussion (Misc queries) | |||
Inputbox and Application.InputBox | Excel Programming | |||
Inputbox | Excel Programming |