+ Reply to Thread
Results 1 to 2 of 2

Created Dropdown list - How to change Font?

  1. #1
    Registered User
    Join Date
    03-24-2006
    Location
    Stafford, England
    MS-Off Ver
    Office 2003
    Posts
    70

    Created Dropdown list - How to change Font?

    I have created a dropdown list for a cell by going to Data>Validation and setting the 'Allow' box to list and then setting the 'Source' box to a pre-defined range. This all works great for populating the dropdown.

    However the text in the dropdown is extremely small. How do you change the font in the dropdown? The selected value appears fine in the actual linked cell because you can change it through Format Cell.

    Thanks in advance

    Jonathan

  2. #2
    Registered User
    Join Date
    08-10-2007
    Posts
    5
    As far as I'm aware, you can't change the font.

    The closest you can come is changing the Zoom ratio. You can do this through VBA when a cell with Data Validation is selected - but it's a pretty ugly way to do it.

+ 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