The ProblemAs I was thinking about how to design a new tool to make VLOOKUP building simpler, I realized there was no control from the Userform Toolbox to do what I see in Microsoft's UI, i.e. to select a range. My concern was not just doing all the programming to create a new control or to add code to one that would allow me to mimic what I saw in the Microsoft UI. Heck, I had never done such a thing and it seemed like a huge learning curve.
- There is a control that does what I want.
- How to add it to my toolbox.
- There is a slew of other controls available.
- Right-click in the toolbox and select "Additional Controls..."
- Scroll down to RefEdit.Ctrl
|Figure 2 - Additional Controls Dialogue|
|Figure 3 - RefEdit.Ctl selected|
|Figure 4 - Toolbox with RefEdit Control|
Two more things!
Removing a control
NOTE: No warning is given after clicking the "Delete Image" option.
Customize a control
|Figure 5 - Tool Customization Dialogue|