I have a spreadsheet that creates a number of combo boxes based on info in
other spreadsheets and then fills them. Even so often, the font of these
combo boxes is set to bold, but not all of them, and it appears almost
random and therefore tricky to track down. So the simplest solution would be
set the font.bold property of the control. However, I can't seem to
reference the combo box once it's been created.
I've used the OLEObjects.Add() contruct to add the combo boxes to
and the .Name property to name the control. The combo boxes have their
LinkedCell property defined and that's how I reference the selected value
for each combo box. The problem seems to be that using this construct adds
it to the Shape collection and that doesn't seem to have a font property.
Any help in simply setting the font to
bold of the combo boxes will be