Argh...layering object problem in userform

[jasonsweeney]

I have a userform with lots of controls on it.

For reasons I won't explain here, I have to place several listboxe
"behind" or underneath some other controls....the user never needs t
click into these listboxes.

Problem is, I can't seem to make them stay behind the other controls.
I try to "Send To Back" and "send backwards" but some of them (?!?!
won't stay behind the other controls.

Very frustating.

Any suggestions

 

[jasonsweeney]

For that matter any help on making these listboxes "not visible".....

Please note that setting the property "visible = false" is not a
option because I do have to set focus on these controls behind th
scenes.

they just won't stay underneath

 

[jasonsweeney]

I fixed it myself...

I think this is a bug in Excel because each time I show the user for
different listboxes that are suppose to be behind other controls appea
each time...sometimes its listbox4, sometimes listbox5...etc.


here is how I worked around it.

First, I made the controls default visible property = false

next, I went into the code and before setting focus and performin
other actions I set the visible property to true.

Finally, to prevent "flashing", I put the listboxes in a frame objec
and then shrunk the margins of the frame so that the listboxes wer
"out of bounds". This seems to work.

- Jason Sweene