Frames are not really supported on a worksheet (plus they look like crap).

I know how to get the control on the frame, but once it is there you can't
do anything with it - their events are not exposed. Anyway once you have the
frame on the worksheet and you are in design mode, right click on the frame
to get a popup window. Then select Frame object and then Edit and a new
Control toolbox toolbar will appear (the same one you see in the vbe) next to
the frame. You can use controls from there and they will be placed on the
frame.


The reason it isn't on the control toolbar by default is because, as I said,
it really isn't supported.

--
Regards,
Tom Ogilvy


"JIPS" wrote:


"JIPS" wrote in message
...
I'm having trouble putting controls into a frame. The way I understand it,
I should be able to either paste controls in or create them in a frame
directly. Neither works for me. I'm using Excel 2003 and when I attempt to
do it, the control will not go into the frame, it will go either over or
under it, I move the frame around and the control stays where it is. Am I
doing this wrong? Any ideas what I can do to make it work? BTW, when I say
control I mean textbox, radiobutton, etc.

Any help would be great!

Also, if it makes any difference, this is on a worksheet, not in a form.

Thanks.