Controls in a Frame

[JIPS]

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!

 

[JIPS]

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.

 

[Tom Ogilvy]

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.

 

[JIPS]

Tom, thanks a lot. Not what I wanted to hear, but definately what I need to
hear. Much appreciated.

I guess I'm approaching this from the wrong way then. Is there a good way to
hide and unhide different groups of controls on a worksheet? I was thinking
I would do it by turning the visibility on and off on a frame, but that
isn't going to work.

 

[Tom Ogilvy]

Perhaps you could name them

grp1Combobox1
grp1Textbox1
grp1Textbox2


for each ole in activesheet.OleObjects
if lcase(left(ole.Name,4)) = "grp1" then
ole.Visible = True
else
ole.visible = False
end if
Next

 

[JIPS]

Tom, thanks so much!

That will work perfectly. Very much appreciated!!!