Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control for Range
Control name is RefEdit
You have to go to Visual Basic editor, create a User form, and then you will see a toolbar with various controls. Drag and drop RefEdit to your form, and look at it's properties to program it. It's fairly intuitive. RADO "Syed Zeeshan Haider" wrote in message ... Hello Experts, I have Excel 97 Pro on Win98SE. I guess there is a control available in VBA for Excel (similar to Formula Palette), which we can use to let the user chose a range for macro. I am attaching the image (ctl.bmp, 886 bytes) of its typical recognition. My questions a What is the name of this control? How to appear it? A macro, written by me, needs a range for running but the user has to type the range in InputBox which is not very wise to me. Thank you, -- Syed Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control for Range
"RADO" wrote in message ...
Control name is RefEdit You have to go to Visual Basic editor, create a User form, and then you will see a toolbar with various controls. Drag and drop RefEdit to your form, and look at it's properties to program it. It's fairly intuitive. Thank you information! Can't it be appeared without a form? Thanks again! -- Syed Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coping Format Control input range to other picklists - HELP!! | Excel Discussion (Misc queries) | |||
Sum Every 4th column in a range tied to a control cell | Excel Worksheet Functions | |||
No range option in format control for combo box | Excel Worksheet Functions | |||
Is it possible to create a dynamic range in CONTROL TOOLBOX (form) | Excel Discussion (Misc queries) | |||
Control for Range | Excel Programming |