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.