How to add Range Input to VBA UserForm

Question

Many of the built in excel dialog boxes use a range input box like this one:

Range input Boxes in Excel

Im not sure if they are called "Range Inputs" or whatever. This is taken from "Data Analysis" in Excel, in case you are wondering. When you click on the little image in the text box, the dialog box disappears and excel allows you to select a range of cells, which it then places in the the text box. If there is a way to incorporate this into a UserForm, please let me know

Thanks in advance!

Pᴇʜ · Accepted Answer · 2015-01-15 07:38:21Z

1

It is called RefEdit Control and works similar to that built in Boxes. If your toolbox does not have a RefEdit control, set a reference to RefEdit control. Click Tools, References, and check Ref Edit Control.

Here is an Example how to use it: http://www.excel-easy.com/vba/examples/userform-ranges.html

answered Jan 15, 2015 at 7:38

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kyle Tegt Over a year ago

Thank you for letting me know/the example, exactly what I needed!

Collectives™ on Stack Overflow

How to add Range Input to VBA UserForm

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related