disappearing controls

[Guest]

Hi Folks,

I’m relatively new to Excel 2000 programming. When I add frames to a
Worksheet with embedded controls (to give the sheet a User Interface look),
the controls are visible in design mode, but disappear (behind the frame?)
when I exit design mode. I have played with every frame/control property and
also tried ordering the shapes, but not having any luck. The slider control
however, is the only one that is visible on top of the frame when not in
design mode – check boxes, combo boxes, and labels seem to disappear.

Is there a way to embed frames into a worksheet that react the same as those
within a Userform?

Thanks,
Andrew

 

[Tom Ogilvy]

You notice that the frame control is not available on the control toolbox
toolbar when you are in a worksheet. It appears to largely be incompatible.

Anyway, once you get the frame on the worksheet, make sure you are still in
design mode. Then right click on the frame and choose edit. Another
toolbox toolbar will appear similar to the one in the vbe. If not, right
click on it in this mode and select toolbar. Now use the controls from
this toolbar to put on the frame.

Bad news - no way to use the events for these controls that I am aware of -
although I have never pursued it that seriously.

You might want to draw a frame or use the one from the forms toolbar
although you won't have the frame functionality.

 

[Guest]

Thanks Tom.

That info will keep me from going insane (for at least a week) - and
actually you've given me an idea that works great...From the control toolbar,
insert a blank Image and a Label, and adjust the border styles and background
colors accordingly. Now it looks just like a frame. Perfect!

Andrew