Change color font and background combo box

  • Thread starter Thread starter stef
  • Start date Start date
S

stef

Excel 2002 SP3
Win XP Pro SP2

Hi,

How can I change the font and background color of combo box I am using?
 
If you got the ComboBox from the Forms toolbar, I don't think you can. If
you got it from the Controls Toolbar, then (when in Design Mode) right-click
it and select Properties from the popup menu that appears.

Rick
 
Rick,
I got it from the Forms toolbar as I use the "Control" tab under "Format
Control" to define the links, etc.
If I use the box from the Controls toolbar, then the "Control" tab in
not available and I imagine VB would be in order to make it do what I
need....
Which would complicate things for me as require VB, etc.
Am I wrong here?
 
I don't use these things too much myself (I'm more of a VBA person myself),
but I think you can do what you current do with the ComboBox from the
Controls Toolbar. When in Design Mode and your right-click the control and
go to the Properties window, you have a LinkedCell, ListFillRange and
ListRows properties which I think duplicates what the "Control Tab" from the
Format Toolbar's ComboBox provides.

Rick
 
Back
Top