Make textbox stay in front of listbox

[ragmag]

Hi

I have a xlsheet with a lot of columns and I want to edit the data record by record with a userform. I use a multi-column listbox to display the records and want a textbox to stay in front to be able to edit data.
Initially it seems ok, but when the listbox gets focus it stays in front of the textbox. Of course I can place the boexes next to each other but it doesn’t look that nice.
How to make the textbox stay in front?

Cheers
ragmag

 

[RobBroekhuis]

Everything in the help files would lead you to believe that the .zorder method of a control is just what you need to do this. Problem is, I've never gotten it to work. The following code should pull the textbox to the top:

userform1.textbox1.zorder

But it doesn't. Maybe someone can set me straight on the proper usage of zorder...
Rob

 

[ragmag]

Hi Rob

I have also tried ZOrder and Userform1.TextBox1.SetFocus, but it doesn't seem to work

Cheers
ragmag