Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I trap a CANCEL without explicitly using a variable? I am using
some code to have the user select a cell with the mouse in conjunction with the InputBox function and want to exit the sub if the user hits cancel. Here is the relevant code. Set Location = Application.InputBox(Prompt:= _ "Using your mouse, select a payee to delete.", Title:="SELECT PAYEE TO DELETE", Type:=8) PayeeAddress = Location.Address Range(PayeeAddress).Select ActiveCell.EntireRow.Delete Shift:=xlUp Thanks guys! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cancel button on messagebox/inputbox | Excel Programming | |||
InputBox - cancel button | Excel Programming | |||
Help with inputbox (Distinguish OK from Cancel) | Excel Programming | |||
Inputbox and cancel button | Excel Programming | |||
Cancel button in Inputbox method | Excel Programming |