control in user defined function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top