View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default 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