Conditional Formatting a Combo Box based on Contents

T

Tatakau

I am trying to set up conditional formatting on a combo box to where if the
combo box has more than 1 item in it, it will change its color. I can't
quite figure out how to write an expression for this though. I've tried
several methods, but it doesn't seem to like my VB. Any suggestions?

Thanks!

Nick
 
D

Duane Hookom

You shouldn't need any code. You can use conditional formatting with
Expression Is like:
combo0.ListCount>1
Change the combo box name to your combo box name.
 
Top