Thread
:
Userform design
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
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 With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]