Changing Font on Combobox (not activeX)

[kerryk525]

Hi I need to change the font on the combobox which is not active X. When i right click there is no font option in the properties.
If i view code on the box;

Sub DropDown3_Change()

End Sub

Help is needed as i have built the box around charts not cells.

 

[SkipVought]

hi,

use an ActiveX control instead if you want to control the font.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kerryk525]

hi Thanks,
I have everything built already and would prefer not to rebuild.
Currently I have drop downs attached to charts instead of 1 cell. If I use active X combo box how do I link the defined 'charts' to the drop down? is it the same as building with the form box

 

[SkipVought]

Drop Downs or ComboBoxes are shapes objects in a sheet; either a worksheet or a chartsheet. Have nothing to do with a cell directly.

That being said, the fact that you have a chart sheet, ActiveX controls are not available, while Forms controls are. And, as you have discovered, the only way to make the font larger is to expand the sheet zoom. Other than that, yer up the creek without a paddle.

As an alternative, move the chart to a sheet and use an ActiveX control on the sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}