Posted to microsoft.public.excel.programming

Fred Smith Fred Smith is offline

external usenet poster

Posts: 623

Test for Cancel in Inputbox

I have the following code segment:

StartDate = Date

StartDate = Application.InputBox("First valid date", , StartDate, , , , , 1)

How can I tell if the user clicked Cancel instead of OK?

--
Regards,
Fred

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
How do I capture CANCEL on an Inputbox?	Toxicdistortion	Excel Programming	3	October 27th 06 01:23 AM
InputBox - cancel button	Greg Billinge	Excel Programming	4	October 11th 04 06:45 PM
InputBox Function & Cancel	Otto Moehrbach[_6_]	Excel Programming	4	September 30th 04 01:13 AM
Clicking Cancel on an Inputbox	rott[_6_]	Excel Programming	3	March 5th 04 02:57 AM
Inputbox and cancel button	Uddinj1	Excel Programming	5	March 2nd 04 11:27 AM

All times are GMT +1. The time now is 12:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us