| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
control in user defined function
I would need to select a range from VBA for a stat. program
I like the control for data entry that show up, if you use a user defined function o the standard functions How can I use this control from the toolbox What is the name of it Anybosy an idea |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
control in user defined function
It is the refedit control.
-- Regards, Tom Ogilvy "Holger" wrote in message ... I would need to select a range from VBA for a stat. program. I like the control for data entry that show up, if you use a user defined function or the standard functions. How can I use this control from the toolbox? What is the name of it? Anybosy an idea? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
control in user defined function
Holger,
You can use the RefEdit control. While you're in design mode for the form in VBA, right-click the Toolbox window and choose More Controls. There, choose the RefEdit control. It works like a normal text box control but lets you select ranges on a worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Holger" wrote in message ... I would need to select a range from VBA for a stat. program. I like the control for data entry that show up, if you use a user defined function or the standard functions. How can I use this control from the toolbox? What is the name of it? Anybosy an idea? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
control in user defined function
Your out of luck then. You can select a range with the mouse using the
refedit or using application.Inputbox(type:=8) that's it. -- Regards, Tom Ogilvy "holger" wrote in message ... No, it's not the refedit, it looks and behaves differently .... ----- Chip Pearson wrote: ----- Holger, You can use the RefEdit control. While you're in design mode for the form in VBA, right-click the Toolbox window and choose More Controls. There, choose the RefEdit control. It works like a normal text box control but lets you select ranges on a worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Holger" wrote in message ... I would need to select a range from VBA for a stat. program. I like the control for data entry that show up, if you use a user defined function or the standard functions. How can I use this control from the toolbox? What is the name of it? Anybosy an idea? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user defined function | Excel Worksheet Functions | |||
| user defined function | Excel Worksheet Functions | |||
| user defined function help | Excel Worksheet Functions | |||
| User Defined Function | Excel Discussion (Misc queries) | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Linear Mode
