View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yogee yogee is offline
external usenet poster
 
Posts: 5
Default Other option of InputBox for range selection

Hi All,
In my vb 6 application,clicking on "pick range" button, I want user to
select range of selection (Like "$A1:$B5") like what
Application.InputBox(prompt:=xPrompt, Title:=xTitle, Type:=0)
does.
But the thing is I DON'T WANT ANY MESSAGE BOX. Just user selects from excel
file and after selection the excel file will become invisible.
Please give me any idea to do that,
Thanks,
-Rajput Yogendrasinh