Combo box bug!!!

[junejunejune]

I have a combo box in one of booksheet. However, when go to other sheets when it's at dropdown mode and i go back again, it will show the first record in the list as this:

dropdown.bmp

How to avoid this?

[salimudheen]

Hi,

How did you bind the Dropdown? Using code or FillListRange property.

I check with FillListRange.

Its working properly. The selected value is always show while navigating the sheet.

Regards,
Salim

[royUK]

An example workbook would be more helpful than a picture!