![]() |
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 |
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