LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Returning a cell address in a msgbox, by selection via inputbox Ty FARAZ QURESHI Excel Discussion (Misc queries) 3 April 8th 09 12:57 PM
Can't Select Range off sheet from inputbox Jim May Excel Discussion (Misc queries) 4 September 29th 07 08:26 PM
Tools - Option - "move selection after enter" jules75 Excel Worksheet Functions 0 August 17th 05 10:56 PM
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. jonH Excel Programming 3 June 7th 04 09:13 PM
Trying to return Range from InputBox Jiana Excel Programming 3 April 28th 04 11:25 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"