Combo box default values

[RWWAMS]

Hi everyone, this is driving me absolutely crazy!!!

I have a two column combo box that I'm populating on the UserForm_Activate event. This is working fine, however, I want to set the default value of the combo box. I would like the default to display both columns of the combo box.

Can this be done and how?

Any feedback would be appreciated!
Excel 2000

 

[TonyJollans]

Hi RWWAMS,

You should be able to set the default via the combo's Text property, but ..

.. a combo has a single value (equal to the value of the bound column in the selected (or defaulted) item). What is displayed may be from a different column in the same item (depending on the textcolumn property) but it can only come from a single column.

Enjoy,
Tony