ActiveX Combobox listrows property being ignored

I have a set of comboboxes set to list the sheetnames in a document for calculating some stuff (it's not important.
The problem I am having is that no matter what I do to the listrows property the dropdown list is only 1 item high with tiny scroll arrows when I first click the dropdown arrow. If I unexpand the list and re-expand it again it works fine it just isn't happy when it is first selected.

I'm pretty sure it is down to the list being cleared and repopulated each time the combobox is selected so the listrow max is set to 0 before the list is populated and is not refreshed untill after the dropdown has expanded with a row count of 0. If I select the box before clicking the dropdown arrow it works fine (again I believe because the list has been populated before the dropdown is expanded).

Anyone know how to resolve this? (I could set the showdropbutton property to when focus but I would rather have a proper solution).

Hello Leon V (AW),

Here is the secret. The F4 key will activate the drop down for a ComboBox.

I have added the SendKeys method to your code to automatically cause the ComboBox list to drop down when the user places the cursor in it.

Please Login or Register  to view this content.

It's not Ideal but I'll take it, thanks.

Hello Leon V (AW),

This can be made to look more like and behave like a Data Validation drop down. The ComboBox "drop down button" can be hidden until the mouse is inside the control or hidden all the time.

Yeah the problem with that is it doesn't hide again after you click out of the box for some reason which is REALLY buggy looking.