Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
how about your button shows a userform. your userform has one control, a
RefEdit control works quite well "yogee" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
Thanks Patrick,
But I don't know about RefEdit control. Will you please tell about that. Thanks again, -Rajput Yogendrasinh "Patrick Molloy" wrote: how about your button shows a userform. your userform has one control, a RefEdit control |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
It is an extra form control.
On the form toolbox, right-click and select more controls, and scroll down and pick RefEDit from that list. Drag it onto your form and play with it. It will look familiar, you will see it in many Excel dialogs. -- HTH RP (remove nothere from the email address if mailing direct) "yogee" wrote in message ... Thanks Patrick, But I don't know about RefEdit control. Will you please tell about that. Thanks again, -Rajput Yogendrasinh "Patrick Molloy" wrote: how about your button shows a userform. your userform has one control, a RefEdit control |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
Thanks for suggesion Bob,
But I when I try do add that control it gives error. "object library invalid or contains object definitions that could not be found" I have search about it but haven't got any concrete answer !!! -yogee "Bob Phillips" wrote: It is an extra form control. On the form toolbox, right-click and select more controls, and scroll down and pick RefEDit from that list. Drag it onto your form and play with it. It will look familiar, you will see it in many Excel dialogs. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
Strange. AT which point do you get that error? And did you select the item
called RefEdit Ctrl? -- HTH RP (remove nothere from the email address if mailing direct) "yogee" wrote in message ... Thanks for suggesion Bob, But I when I try do add that control it gives error. "object library invalid or contains object definitions that could not be found" I have search about it but haven't got any concrete answer !!! -yogee "Bob Phillips" wrote: It is an extra form control. On the form toolbox, right-click and select more controls, and scroll down and pick RefEDit from that list. Drag it onto your form and play with it. It will look familiar, you will see it in many Excel dialogs. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
I selected the item RefEdit ctrl and click on ok which gave me that error. Do
I need to add any reference for that ??? I am using office XP 2003 Thank You, -yogee "Bob Phillips" wrote: Strange. AT which point do you get that error? And did you select the item called RefEdit Ctrl? -- HTH RP (remove nothere from the email address if mailing direct) "yogee" wrote in message ... Thanks for suggesion Bob, But I when I try do add that control it gives error. "object library invalid or contains object definitions that could not be found" I have search about it but haven't got any concrete answer !!! -yogee "Bob Phillips" wrote: It is an extra form control. On the form toolbox, right-click and select more controls, and scroll down and pick RefEDit from that list. Drag it onto your form and play with it. It will look familiar, you will see it in many Excel dialogs. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Other option of InputBox for range selection
Sorry I have clicked on "yes" button (was this post helpful to you?) wrongly
in Bob's question and I am not able to back trace now... So it's shows my qustion as answered but it's not answered "yogee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a cell address in a msgbox, by selection via inputbox Ty | Excel Discussion (Misc queries) | |||
Can't Select Range off sheet from inputbox | Excel Discussion (Misc queries) | |||
Tools - Option - "move selection after enter" | Excel Worksheet Functions | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Trying to return Range from InputBox | Excel Programming |