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

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?

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?

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?