Thread: Test for Cancel in Inputbox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
  
Posts: 623
Default 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 QuoteReply With Quote