| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cancel/Exit Sub
This code works but, how can I exit this code if I hit "Cancel" or "OK?"
Field (column) 7 has either a yes or a no in the cell. With ActiveSheet .UsedRange.AutoFilter Field:=7, Criteria1:=InputBox(prompt:="Enter Yes or No") .PageSetup.Orientation = xlLandscape .PrintOut .UsedRange.AutoFilter End With Range("A1").Select Thanks, -- Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exit Code Upon Cancel On Type 8 Input Box | Excel Discussion (Misc queries) | |||
| InputBox / VBA question ok = print, cancel = exit | Excel Worksheet Functions | |||
| cancel input | Excel Discussion (Misc queries) | |||
| can I cancel a save | Excel Discussion (Misc queries) | |||
| Read Only - How to Cancel? | Excel Discussion (Misc queries) | |||
Threaded Mode
