+ Reply to Thread
Results 1 to 2 of 2

change font in a forms control combo box

  1. #1
    JRTB
    Guest

    change font in a forms control combo box

    Am trying to change font in a combo box in Excel 2003 but cant figure out how
    to. The font appears to be a default size and style regardless of how large
    I make the combo box. I have canged the size of font in the linked list but
    this does not work. Any help welcomed.

  2. #2
    Nick Hodge
    Guest

    Re: change font in a forms control combo box

    I suspect you are trying to use a combobox from the 'forms' toolbar. The
    font in these is fixed.

    If you use the 'controls' toolbox you will get an activeX control in which
    you can change the font attributes. You also used the 'linkedcell' property
    and 'ListFillRange' to fill and display values from the control.

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


    "JRTB" <JRTB@discussions.microsoft.com> wrote in message
    news:A75D0A20-5C7B-40E2-882B-94B8AB6E65AD@microsoft.com...
    > Am trying to change font in a combo box in Excel 2003 but cant figure out
    > how
    > to. The font appears to be a default size and style regardless of how
    > large
    > I make the combo box. I have canged the size of font in the linked list
    > but
    > this does not work. Any help welcomed.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1