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

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

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]

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

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