View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stindle stindle is offline
external usenet poster
 
Posts: 4
Default need form pulldown white while box is color

I have a user form with many pull downs using VBA in Excel. The color of the
result box changes color depending on the value. No problem there; however,
not only is the result box changing color so is the pull down with the other
values. Is there a way to change the result box and not change the pull down
color? My boss wants the pulldown to remain white so the user can see the
other possible values.

I thought about using events on click but that's not an option for pull downs.

TIA
Steve