Posted to microsoft.public.excel.programming

Rafi

external usenet poster

Posts: 27

InputBox Cancel event

I have the following code prompting the user to select a range.

Set rng = Application.InputBox(Msg1, Title1, Type:=8)

I need to be able to trap both a CANCEL event as well as when the user
clicks "OK" without selecting a range.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
InputBox Cancel Button	A Mad Doberman	Excel Programming	1	June 20th 08 09:49 PM
Test for Cancel in Inputbox	Fred Smith	Excel Programming	5	April 6th 07 03:36 AM
How do I capture CANCEL on an Inputbox?	Toxicdistortion	Excel Programming	0	October 27th 06 12:37 AM
InputBox Function & Cancel	Otto Moehrbach[_6_]	Excel Programming	4	September 30th 04 01:13 AM
Inputbox and cancel button	Uddinj1	Excel Programming	5	March 2nd 04 11:27 AM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us