What Excel VBA control is most appropriate for capturing a user selected range?

RefEdit control
4 Answers. This control is called RefEdit control. To use it, you have to first add it to the toolbox window by right-clicking in the toolbox window and selecting Additional Controls…. Then you select RefEdit. Ctrl and close the dialog.

Does Excel use VB or VBA?

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros.

What is RefEdit EXD?

It may also be necessary to remove RefEdit. exd files from a user’s computer if problems occur and unchecking the reference doesn’t fix them. these exd files are temporary files that contain instructions Excel uses to build RefEdits, and the exd may conflict with the RefEdits in the workbook.

Where is the refedit control in VBA 2?

The RefEdit Control by default is not available on the Control Toolbox. To locate and add this Control to the Toolbox, right click over any Control on the Toolbox, select Additional Controls and scroll down until you see the Control RefEdit.Ctrl . Simply check the box and click OK.

Where do I find the refedit button in Excel?

In the Control Toolbox, click RefEdit Control and place the control on your UserForm1. If you are unsure which button is the RefEdit button, wave your mouse over the button and you will see the a ToolTip with the button name. In the Control Toolbox, click the CommandButton Control and place the CommandButton on your UserForm.

How to create refedit control on Excel userform?

Add the label, RefEdit control and command buttons. Once this has been completed, the result should be consistent with the picture of the Userform shown earlier. For example, create a RefEdit control by clicking on RefEdit from the Toolbox. Next, you can drag a RefEdit control on the Userform.

Can a refedit control be embedded in a worksheet?

If the RefEdit control is embedded on a worksheet, you can link the contents of the control to a cell on any worksheet in that workbook. The default property for a RefEdit control is Value. The default event for a RefEdit control is BeforeDragOver. You cannot use a RefEdit control on a modeless user form (applies only to Excel 2000+).