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

Hi,

I am using the inputbox to get a user to pick a cell on a worksheet and am
having trouble trapping a Cancel event or when the user clicks OK without
making a selection

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

Please note that rng is dimmed as an object