Conditional Formatting a Combo Box based on Contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top