Control Box vs. Form Box

[topshotta]

I would like to put a combo box from the forms toolbar on a spreadsheet I'm currently working on, however I have no control over the font size within the box. I know that combo box within the control form will allow me to change font size, but then the forms tab isn't listed under properties/format control. Can anyone suggest a workaround? It's very important that I'm able to control the size of the font in addition to being able to access the format control.

Thanks,
David

 

[Ron Morris]

Hi,

You could use the Combobox from the ActiveX control toolbar and then right click on the combobox. Then click on properties.

The Listfillrange is similar to the Input range of the Forms Combobox and the LinkedCell is the same a Cell Link, but instead of returning the number of where the item is in the list it will return the actual value.

Hope this is what you need.

Ron