| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activating the cancel button on Input boxes
Hi all, I have a type 8 (range) input box. How can I make the procedure
exit when the user clicks on the cancel icon on the input box without getting an error. Many thanks S |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activating the cancel button on Input boxes
dim rng as Range
On Error Resume Next set rng = Application.Inputbox("Prompt", Type:=8) On Error goto 0 if rng is nothing then msgbox "No range selected" exit sub End if -- Regards, Tom Ogilvy "Shane" wrote in message ... Hi all, I have a type 8 (range) input box. How can I make the procedure exit when the user clicks on the cancel icon on the input box without getting an error. Many thanks S |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activating the cancel button on Input boxes
THANK YOU!!!
"Tom Ogilvy" wrote in message ... dim rng as Range On Error Resume Next set rng = Application.Inputbox("Prompt", Type:=8) On Error goto 0 if rng is nothing then msgbox "No range selected" exit sub End if -- Regards, Tom Ogilvy "Shane" wrote in message ... Hi all, I have a type 8 (range) input box. How can I make the procedure exit when the user clicks on the cancel icon on the input box without getting an error. Many thanks S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input Box Cancel | Excel Discussion (Misc queries) | |||
| cancel input | Excel Discussion (Misc queries) | |||
| Input Box Cancel Button | Excel Programming | |||
| Activating A Query from An Input Box | Excel Programming | |||
| input box cancel button | Excel Programming | |||
Linear Mode
