| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputbox error when clicking cancel
If someone uses this code, but clicks cancle on the inputbox you get a code
error. What cacode can be added to prevent this error? Sub SelectRange() Dim UserRange As Range Set UserRange = Application.InputBox( _ prompt:="Please input or select a range", Type:=8) UserRange.Font.Bold = True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cancel on INPUTBOX macro causes error | Excel Programming | |||
| InputBox Function & Cancel | Excel Programming | |||
| Help with inputbox (Distinguish OK from Cancel) | Excel Programming | |||
| Clicking Cancel on an Inputbox | Excel Programming | |||
| Inputbox and cancel button | Excel Programming | |||
Threaded Mode
