MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text Box for selecting Ranges

Posted by Richie Turner on January 15, 2002 8:22 AM


I'm putting together a form in VBA. Does anyonbe know where I can get hold of the control that allows the user to select a range from the worksheet.
It looks like a normal textbox but has a button on the right hand side, like the one on Step 2 of the Chart Wizard, labelled Data Range, the user can click the small button and the whole form shrinks so you can see the rest of the sheet, select your range, expand the form again and continue.

Would be grateful for any information as to where I can find it and any tips on its use.



Posted by Juan Pablo G. on January 15, 2002 9:18 AM

It's called RefEdit and it's in the Contorl Toolbar that appears when you are editing a Userform.

Juan Pablo G.