Changing the text in a list box in an Excel Spreadsheet
 

Russ Hugenschmidt wrote:
How can I change the size, font and color of the font
that defaults when I insert a list box?


From Forms toolbar: you can't
From Control Toolbox: I don't think you can either.

For use in a user-form you can define your own variant controls by
formatting one on a form and dragging it to the Toolbox. I don't
believe the same can be done on a worksheet.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup