VBA userform Z-order not working

[Grahhhhh]

I'm strictly trying to improve aesthetics of my userform. I have over 200 labels, checkboxes, textboxes, buttons, etc. I wanted to add a frame control with a darker background to place behind some of the controls at different times (so it doesn't make sense to put the controls within the frame(strictly aesthetic)), however since the frame is the most recent object I added to the userform, it's layered as the top most object.

The problem is that programmatically setting the z-order doesn't seem to do anything, and the option: Format--> Order --> Send to back/Send backwards is grayed out.

I'm not certain why I'm being blocked out from accessing the z-order, what am I missing?

 

[RedBeard]

This might be of help: https://www.ozgrid.com/forum/forum/...ral/79138-control-zorder-of-userform-controls

 

[Grahhhhh]

Thanks RedBeard, I've seen that post, and had tried reorganizing per those methods and still no effect. It boggles me because I know what I want to do, and theoretically how to do it, but for some reason VBA doesn't respond

 

[RoryA]

The Z order of container controls (like frame or multipage) is only relative to other container controls, so you can't do what you want. I suggest you use a different type of control - eg a textbox or label - to give the appearance you are after.

 

[Grahhhhh]

No kidding. Huh... yeah, what you're saying makes sense. I guess I put my blinders on and didn't consider that it didn't have to be a frame, only that the frame order wasn't "working". Thanks!