Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform design
I have created a userform which consists of several comboboxes.
When a user selects a combobox it is resized, this is done using the code:- Private Sub combobox_enter() comboboxox.height=60 End Sub when the user exits the combobox it re-sized to its original size using the code Private Sub Combobox_Exit(ByVal Cancel As MSForms.ReturnBoolean) combobox.Height = 30 End Sub my problem is that if, when using the form a user wishes to re-enter a combox, when the combobox is select and re-sized,the combobox beneath it is obsuring it, as it appears to be on top it. Therefore what I need is some code to ensure that the combobox selected should appear above all other objects on the form. Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform design
You need to set the ComboBox.Zorder
-- Jim Cone Portland, Oregon USA "nir020" wrote in message I have created a userform which consists of several comboboxes. When a user selects a combobox it is resized, this is done using the code:- Private Sub combobox_enter() comboboxox.height=60 End Sub when the user exits the combobox it re-sized to its original size using code Private Sub Combobox_Exit(ByVal Cancel As MSForms.ReturnBoolean) combobox.Height = 30 End Sub my problem is that if, when using the form a user wishes to re-enter a combox, when the combobox is select and re-sized,the combobox beneath it is obsuring it, as it appears to be on top it. Therefore what I need is some code to ensure that the combobox selected should appear above all other objects on the form. Please help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform design
This sets the control on top of others......
ComboBox_Exit.ZOrder (0) -- Regards, Nigel "nir020" wrote in message ... I have created a userform which consists of several comboboxes. When a user selects a combobox it is resized, this is done using the code:- Private Sub combobox_enter() comboboxox.height=60 End Sub when the user exits the combobox it re-sized to its original size using the code Private Sub Combobox_Exit(ByVal Cancel As MSForms.ReturnBoolean) combobox.Height = 30 End Sub my problem is that if, when using the form a user wishes to re-enter a combox, when the combobox is select and re-sized,the combobox beneath it is obsuring it, as it appears to be on top it. Therefore what I need is some code to ensure that the combobox selected should appear above all other objects on the form. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform design - keyboard to move controls? | Excel Programming | |||
UserForm does NOT save changes to design (Excel 2000) | Excel Programming | |||
How to format userform label at design time? | Excel Programming | |||
Control Toolbox does not appear when trying to design a Userform! | Excel Programming | |||
Nudging controls in UserForm Design Mode | Excel Programming |