View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rafi Rafi is offline
external usenet poster
 
Posts: 27
Default InputBox Cancel event

How do I trap a Cancel event on the following code? I have tried the most
common IF statements however, the code blows up before getting to the IF
statement when CANCEL is clicked.

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