Change color font and background combo box

[stef]

Excel 2002 SP3
Win XP Pro SP2

Hi,

How can I change the font and background color of combo box I am using?

 

[Rick Rothstein \(MVP - VB\)]

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

 

[stef]

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?

 

[Rick Rothstein \(MVP - VB\)]

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

 

[stef]

OK, that could very well be.
I will check on it and post back here if success.