|  | Change color font and background combo box | | |
| | | stef |  |
|  Posted: Wed Jun 11, 2008 1:13 am Post subject: Change color font and background combo box |  |
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) | |
| | Posted: Wed Jun 11, 2008 1:33 am Post subject: Re: Change color font and background combo box | |
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" <notvalid@nomail.nul> wrote in message
news:OlF3UE3yIHA.3624@TK2MSFTNGP04.phx.gbl...
| Quote: | Excel 2002 SP3
Win XP Pro SP2
Hi,
How can I change the font and background color of combo box I am using?
|
|
| |
| | | stef | |
| | Posted: Wed Jun 11, 2008 1:44 am Post subject: Re: Change color font and background combo box | |
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) wrote:
| Quote: | 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" <notvalid@nomail.nul> wrote in message
news:OlF3UE3yIHA.3624@TK2MSFTNGP04.phx.gbl...
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) | |
| | Posted: Wed Jun 11, 2008 2:08 am Post subject: Re: Change color font and background combo box | |
| |  | |
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" <notvalid@nomail.nul> wrote in message
news:%23PtipV3yIHA.2064@TK2MSFTNGP05.phx.gbl...
| Quote: | 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) wrote:
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" <notvalid@nomail.nul> wrote in message
news:OlF3UE3yIHA.3624@TK2MSFTNGP04.phx.gbl...
Excel 2002 SP3
Win XP Pro SP2
Hi,
How can I change the font and background color of combo box I am using?
|
|
| |
| | | stef | |
| | Posted: Wed Jun 11, 2008 2:13 am Post subject: Re: Change color font and background combo box | |
OK, that could very well be.
I will check on it and post back here if success.
Rick Rothstein (MVP - VB) wrote:
| Quote: | 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" <notvalid@nomail.nul> wrote in message
news:%23PtipV3yIHA.2064@TK2MSFTNGP05.phx.gbl...
|
|
| |
|
|
