Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The unnamed range selection button
There's a box that is used on many of the excel forms that when yo click it it lets you choose a range of values on the sheet. I'm no sure of the exact terminology of what kind of button this is so I'v attached a screen cap. My question is two parts: a) what is this mysterious button called, and b) is there anyway to use it on a custom userform? thanks, Mar +------------------------------------------------------------------- |Filename: miscellaneous box.jpg |Download: http://www.excelforum.com/attachment.php?postid=5027 +------------------------------------------------------------------- -- MDubbelboe ----------------------------------------------------------------------- MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633 View this thread: http://www.excelforum.com/showthread.php?threadid=56126 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The unnamed range selection button
oh never mind. i'm an idiot Ref Edit, and it's quite clearly marked.. -- MDubbelboe ----------------------------------------------------------------------- MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633 View this thread: http://www.excelforum.com/showthread.php?threadid=56126 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The unnamed range selection button
Hi Mark,
MDubbelboer wrote: There's a box that is used on many of the excel forms that when you click it it lets you choose a range of values on the sheet. I'm not sure of the exact terminology of what kind of button this is so I've attached a screen cap. My question is two parts: a) what is this mysterious button called, and That's the RefEdit control. b) is there anyway to use it on a custom userform? Yes - it should show up in the controls toolbox when a UserForm is active. -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The unnamed range selection button
If you check around, you will probably find many post concerning the
troubles/pitfalls of using this control. You need to be careful with your coding. e.g. http://groups.google.co.uk/group/mic...ae2df6 b749ca NickHK "MDubbelboer" wrote in message ... oh never mind. i'm an idiot Ref Edit, and it's quite clearly marked... -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=561268 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
The unnamed range selection button
NickHK Wrote: If you check around, you will probably find many post concerning the troubles/pitfalls of using this control. You need to be careful with your coding. e.g. http://tinyurl.com/er295 NickHK Starting to notice that. I tried using it last night and it kep freezing my excel. This morning when I woke up (yes I did dream abou it) I thought it might have something to do with the fact my userfor was modeless, that link confirms that. thank -- MDubbelboe ----------------------------------------------------------------------- MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633 View this thread: http://www.excelforum.com/showthread.php?threadid=56126 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unnamed Macro Error | Excel Worksheet Functions | |||
Removing unnamed Legend lines from an Excel template | Charts and Charting in Excel | |||
navigating to an unnamed spawned window ? | Excel Programming | |||
Finding unnamed cells in a range | Excel Discussion (Misc queries) | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |