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

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

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