Not select any ComboBox item?

[VAer]

Please Login or Register  to view this content.

How to NOT select any ComboBox item when opening a workbook? Both items are equally important, and I prefer to let user to choose. Not prefer to have default selected item.

Is it possible not to have any item selected, while there is no blank item available?

Thanks.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[VAer]

Try this...

Please Login or Register  to view this content.

Thanks. But I just realize that there is a new issue if leaving it blank. I don't know why the code in Sheets("Test") ComboxDatabase_Change will also run after finishing the Workbook code. There will be problem to run ComboxDatabase_Change if the ComboBox is blank.

[AlphaFrog]

To suppress running your _Change event code on open, try this.

Declare this public variable at the top of any standard code module e.g; Module1

Please Login or Register  to view this content.

This add this line...

Please Login or Register  to view this content.

And add this to your ComboxDatabase_Change procedure

Please Login or Register  to view this content.