control in user defined function

H

Holger

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
 
C

Chip Pearson

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
 
T

Tom Ogilvy

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