2015-05-27

I want to show a placeholder in a ComboBox if no values has yet been selected. That work like a charm using @;"My placeholder" as the Format of the ComboBox. So far so good.

The problem starts if my ComboBox has more than one column. How can you set the placeholder value for a multi-column ComboBox? More general: How can you specify the Format for a multi-column ComboBox?

Is it for example possible to color the first column green and the second one red? And if it is possible, please tell me how.

I could not find any specification on how to set the format for multiple columns. Neither on MSDN nor on support.office.com.

P.S.: I do not care if a working solution relies on VBA or if it can achieved just by entering something in the layout or design view.

Show more