I have a user form with a frame control that has some labels, etc. within. I then added a text box to the form (not to the frame) but it is partially hidden behind the frame control. I tried setting the Zorder (textbox1.zorder(0)) when the user form is initialized but it still remains partially hidden by the Frame. Does the Zorder work in VBA?
EssoExplJoe
You are using the wrong language. VBA does not have Zorder property for its ActiveX controls. That applies to InterOp which part of VB.net.
You have to select the control on the UserForm then use the context menu (Right Click) commands "Bring Forward" or "Send Backward" to change the Z order.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hey Joe,
Because you are using controls on a Userform, it sounds like you are looking for the Tab Order, which is a property of each control on the userform.
https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I am using controls on UserForms which I don't think are active X. However, I think you are correct i that the Zorder doesn't seem to work for VBA UserForm controls.
No, I am trying to bring a textbox control in front of a frame control which is the zorder, not tab selection order.
Listboxes, Frames and Multipages always stay as close to the front of the ZOrder as they can. You can move them relative to other controls of those three types, but not behind a textbox or other control.
Last edited by xlnitwit; 09-28-2017 at 12:06 PM. Reason: Typo
Don
Please remember to mark your thread 'Solved' when appropriate.
Hello EssoExplJoe,
There are only 3 types of control used in Excel: HTML, Forms, and ActiveX. All VBA controls, including the UserForm, are ActiveX controls. The old name these controls was OLE.
To add to xlnitwit post, the controls he mentions (Frame and Multipage) are known as "containers". These are controls that can host other controls. That is why these will be on top of the UserForm.
Thanks. I had a text box that I wanted to be on top of a user frame but I guess will have to actually put it in the frame.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks