Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form - Range Selector
Could someone show me some sample code of a user form that has a data range
selector similar to the pivot table wizard and chart wizard? -- Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form - Range Selector
there really isn't any code to show - you should add the control manually.
You are looking for the Refedit control. It should be in the control toolbox, or if not, look in the tools menu in the VBE for add more controls. It should be listed alphabetically as refedit.ctrl or something very close to that. -- Regards, Tom ogilvy "Mike Archer" wrote: Could someone show me some sample code of a user form that has a data range selector similar to the pivot table wizard and chart wizard? -- Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range picker / selector | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
User form browsing for a range on a sheet? | Excel Programming | |||
passing a range to a user defined function using a form | Excel Programming | |||
My First User Form - How to Select Range(s) and Print | Excel Programming |