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

I have the following inputbox and need to trap erros

Set Rng= Application.InputBox(Msg1, Title1, Type:=8) where Rng is dimmed as
an object

1) how do I trap the user response if they click cancel
2) how do i tarp the user response if the click Enter without selecting a
range