Consulting

Results 1 to 4 of 4

Thread: Solved: Change font and/or size for validation list

  1. #1

    Solved: Change font and/or size for validation list

    As in the title: Is it possible somehow to change font and/or size for a validation list?
    I'm using several validation lists and it is quite small. Once choice is made, it changes automatically when in the cell, but would be nice to see the choices bigger.

    Thanks for any input.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Not possible using Data Validation. A combo box, yes, DV, no.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    For some alternatives, check out MS MVP Debra Dalgleish's site ...

    http://www.contextures.com/xlDataVal08.html#Font

  4. #4
    Thanks for the tip, will check it out. => Done.

    Excellent site and tips. Very tempting, but finally decided to stick with VL as I don't want to have macro in the worksheet, but stashed link for later use.

    Thanks again.

Posting Permissions

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