Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Box Cancel
I am using an input box, when i select the cancel button on my input box it
gives me a debug. Do I need to code this button to cancel? if so how? thanks, Jase |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Box Cancel
Try code something like this... it allows only numbers in the input box and
validates for numbers less than 1... Sub test() Dim var As Variant var = Application.InputBox("please enter the number of sheets.", Type:=1) If var < 1 Then MsgBox "Won't print" Else MsgBox "Print " & var & " copies" End If End Sub -- HTH... Jim Thomlinson "Jase" wrote: I am using an input box, when i select the cancel button on my input box it gives me a debug. Do I need to code this button to cancel? if so how? thanks, Jase |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Box Cancel
Num = InputBox("Enter a number ")
If Num = "" Or Not IsNumeric(Num) Then MsgBox "you have cancelled or not entered a valid number" End If Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 11:54:01 -0700, Jase wrote: I am using an input box, when i select the cancel button on my input box it gives me a debug. Do I need to code this button to cancel? if so how? thanks, Jase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exit Code Upon Cancel On Type 8 Input Box | Excel Discussion (Misc queries) | |||
Alerts - how to cancel | Excel Discussion (Misc queries) | |||
Input Box - CANCEL | Excel Worksheet Functions | |||
Save - Yes / No / Cancel | Excel Discussion (Misc queries) | |||
cancel input | Excel Discussion (Misc queries) |