ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to change the font used by dropdown list box? (https://www.excelbanter.com/excel-programming/416769-how-change-font-used-dropdown-list-box.html)

Herbert Chan

How to change the font used by dropdown list box?
 
Hello,

I have set up a dynamic chart sheet. I put a dropdown box control on the
chart sheet such that I can change what data to show directly from the chart
sheet. It all works well. However, there is an aesthetic problem. I want
to change the dropdown box control to use another font such that the
dropdown box will look nicer. I've looked and looked, but cannot find where
I can make such changes to the property of the dropdown box control.

Could anyone here tell me how to change the font used by a dropdown box
control?

Herbert



LLT

How to change the font used by dropdown list box?
 
Hi Herbert,

If you are using a "Form" combobox control, I am afraid it may not be
possible. If you use an "ActiveX" combobox control, go to its properties and
Font is listed for modification.

To know what type of control you are using, right-click on it. If you have a
"properties" option, it is an ActiveX one, otherwise, it is a Form one.

I hope it helps,

Regards,
Leo

"Herbert Chan" wrote in message
...
Hello,

I have set up a dynamic chart sheet. I put a dropdown box control on the
chart sheet such that I can change what data to show directly from the
chart sheet. It all works well. However, there is an aesthetic problem.
I want to change the dropdown box control to use another font such that
the dropdown box will look nicer. I've looked and looked, but cannot find
where I can make such changes to the property of the dropdown box control.

Could anyone here tell me how to change the font used by a dropdown box
control?

Herbert





All times are GMT +1. The time now is 05:43 PM.

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