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

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.