ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a way to have different fonts and/or formats in a combo b (https://www.excelbanter.com/excel-worksheet-functions/24523-there-way-have-different-fonts-formats-combo-b.html)

TNTraining

Is there a way to have different fonts and/or formats in a combo b
 
I would like to have different fonts and/or formats in my combo box list.
For example, I would like one row to be underlined and the rest not
underlined. OR the first row highlighted and the rest not. is this possible?

I can use a validation list instead but it doesn't do this either.

thanks in advance!!

Jimbola

Nope afraid you can't.
It believe it is possible to do this using VB.

"TNTraining" wrote:

I would like to have different fonts and/or formats in my combo box list.
For example, I would like one row to be underlined and the rest not
underlined. OR the first row highlighted and the rest not. is this possible?

I can use a validation list instead but it doesn't do this either.

thanks in advance!!


TNTraining

Thanks Jimbola -- do you or anyone out there know how to do this in VB?

"Jimbola" wrote:

Nope afraid you can't.
It believe it is possible to do this using VB.

"TNTraining" wrote:

I would like to have different fonts and/or formats in my combo box list.
For example, I would like one row to be underlined and the rest not
underlined. OR the first row highlighted and the rest not. is this possible?

I can use a validation list instead but it doesn't do this either.

thanks in advance!!


Bob Phillips

The font property applies to the combobox, not an element, so I don't think
this is possible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TNTraining" wrote in message
...
Thanks Jimbola -- do you or anyone out there know how to do this in VB?

"Jimbola" wrote:

Nope afraid you can't.
It believe it is possible to do this using VB.

"TNTraining" wrote:

I would like to have different fonts and/or formats in my combo box

list.
For example, I would like one row to be underlined and the rest not
underlined. OR the first row highlighted and the rest not. is this

possible?

I can use a validation list instead but it doesn't do this either.

thanks in advance!!




TNTraining

Thanks Bob... I afraid that was the answer!

"Bob Phillips" wrote:

The font property applies to the combobox, not an element, so I don't think
this is possible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TNTraining" wrote in message
...
Thanks Jimbola -- do you or anyone out there know how to do this in VB?

"Jimbola" wrote:

Nope afraid you can't.
It believe it is possible to do this using VB.

"TNTraining" wrote:

I would like to have different fonts and/or formats in my combo box

list.
For example, I would like one row to be underlined and the rest not
underlined. OR the first row highlighted and the rest not. is this

possible?

I can use a validation list instead but it doesn't do this either.

thanks in advance!!






All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com