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

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" <(E-Mail Removed)> wrote in message
news:eM%(E-Mail Removed)...
> 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
>