zOrder

[AlexanderBB]

I'm having trouble with zOrder. Is it for Form controls, or not? I see references to shapes but not sure what they are.

I've tried msoSendToBack (1), and msoBringToFront (0) each way on a Useform label and listview control and nothing does anything.
According to MSHelp there's also 'msoSendBackward' (3) but that just brings up an error here.

If zOrder doesn't work with a Label & Listview, is there some other way to show the label over the listview?
Thanks.

 

[Jon Peltier]

I assume you mean a listbox.

On a UserForm, most controls can be placed in front of or behind other controls.

However, no control can be placed in front of a listbox. And only a listbox can be placed in front of a frame (although other controls can be placed into the frame, which is itself a container).

 

[AlexanderBB]

John, I did mean listview, which reminds me I must test the workbook in another comp and see if listview still works.
And if you know how, ever used a FlexGrid? Mine tells me something about "not trusted" and Googling that gives you a headache.
So maybe it's like a listbox and nothing can go in front if it? So I shall stop trying. And yes, it's all on a Frame. How did you know ?

 

[Jon Peltier]

A quick search instructed me on ListView controls. I suspect its behavior is similar to a ListBox.

You're not going to have 32/64-bit incompatibility issues, are you?

 

[AlexanderBB]

> You're not going to have 32/64-bit incompatibility issues, are you?

I wouldn't be surprised, but I haven't a 64 bit Excel to test with. So guess it's 32 bit or the highway...