Set .List if there is nothing to choose.

[Frigide]

I have this script so a user can choose a list. But sometime there is nog choice. How can i set a value if there is noting to choose?

Please Login or Register  to view this content.

Does not work gives a .value error.

Please Login or Register  to view this content.

[Akuini]

Try:

Please Login or Register  to view this content.

[torachan]

the combobox listindex will be -1, so use this to either directly exit the sub or trigger a message box informing no data available