i have the following line in a procedure.
with combobox on sheet1

sheet1.ComboREGISTER.DropDown

it works fine if an item is selected. dropdown menu 'close', but if user
selects sheet2 without selecting an item in combobox ,page2 appears and so
does the dropdownmenu eventhough no combobox exists on sheet2. How can i
"close" dropdown menu on sheet change. This problem only occurs if .dropdown
is used. If user clicks combobox to show menu and then switches page menu
close automatically. Please someone help as other sheets need to be
available (i don't want to hide them)

Sunil

sunilpatel;363479 Wrote:
i have the following line in a procedure.
with combobox on sheet1

sheet1.ComboREGISTER.DropDown

it works fine if an item is selected. dropdown menu 'close', but if
user
selects sheet2 without selecting an item in combobox ,page2 appears and
so
does the dropdownmenu eventhough no combobox exists on sheet2. How can
i
"close" dropdown menu on sheet change. This problem only occurs if
.dropdown
is used. If user clicks combobox to show menu and then switches page
menu
close automatically. Please someone help as other sheets need to be
available (i don't want to hide them)

Sunil

Hello Sunil,

The ComboBox should close the drop down list as soon as the control
loses focus to another object or the focus is switched back to control's
text edit box. It could be Excel is failing to properly repaint the
workbook when you change sheets, which can be due to low resources. Is
the control still active when you change sheets? Can you actually select
an item in the drop down?

Sincerely,
Leith Ross


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101905