Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Change font size in drop down lists

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I increase the font size in my drop down lists? I often have to zoom my sheets smaller which makes the drop down boxes almost impossible to see. I'd like to up the text to about 14pt or higher - is this possible using the basic forms menu? Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One easy way to accomplish this is to change what you use for your drop downs.
    Instead of using the forms method use the data validation method.
    1-Toolbar..Data..Validation..select "setting tab".
    2-Under "allow" select list
    3-in "source" txtbx type comma seperated list of items to select from
    (if you need a dynamic list use a named group instead of hardcoded list)

    4- To change font size etc just change the format of the cell you made the dropdown list in... you can change any format aspect of this cell

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have never been able to change font size or type in validation lists. Whatever the cell is formatted as, the validation list always uses default settings. If you have any luck in changing these settings, please let me know how you did it, because I and many others have tried and failed in the past.

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 00:48, Mr Nick wrote:
    I have never been able to change font size or type in validation lists. Whatever the cell is formatted as, the validation list always uses default settings. If you have any luck in changing these settings, please let me know how you did it, because I and many others have tried and failed in the past.
    Works for me in Excel2000
    What version are you using 97??

    Why not use the Combbox from the control Toolbox, there are more Properties avail
    using this ActiveX control.
    _________________
    Kind Regards,
    Ivan F Moala
    Have a Nice day

    [ This Message was edited by: Ivan F Moala on 2002-05-07 01:56 ]

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm using Excel 97.

    I have often tried and failed to use Wingdings formatting in validation boxes to enter ticks and crosses but although the cell is formatted as wingdings, the actual dropdown still shows and . Also, the dropdown does not use the same text size as the cell.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have just tried on 2002 and the validation list cannot be formatted on that either.

    Ivan, does your actual list format change or just the cell?

    I have tried using the combobox as you suggest but a lot of my sheets have formatting changes that occur on activation of certain macros and the combo boxes do not resize to match these changes. Is it possible to lock a combobox to a cell so it matches the cell size?

  7. #7
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 03:09, Mr Nick wrote:
    I have just tried on 2002 and the validation list cannot be formatted on that either.

    Ivan, does your actual list format change or just the cell?

    I have tried using the combobox as you suggest but a lot of my sheets have formatting changes that occur on activation of certain macros and the combo boxes do not resize to match these changes. Is it possible to lock a combobox to a cell so it matches the cell size?
    Hi Mr Nick...my appologies the ACTUAL list font doesn't change...was thinking about the
    actual Cell....the dropdown list font
    canot be changed AFAIK.

    As far as the comboboxs go...
    Just select them and on the Drawing Toolbar
    Select > Draw > Snap > toGrid

    Then just size to the cell...it won't allow
    you to go out side of a cell.
    Also set the combobox to [Move & size with cells] so that resizing cells will adj automatically.


    Kind Regards,
    Ivan F Moala From the City of Sails

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 03:22, Ivan F Moala wrote:
    the dropdown list font
    canot be changed AFAIK.
    Ivan,

    what's "AFAIK" ?

    All fonts something ?

    something something I know ?

    ta
    Chris

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    as far as i know


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #10
    New Member
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks all for trying - I had hoped it was something simple but obviously not. How frustrating. BTW I've previously got around this problem by using the check box or option button and adding a text box on top. If your option button is big enough you can bring it to the front of the text box and if you click the word, your option button will trigger. Obviously this takes time - and space on the sheet! - but I've found it useful for less complicated sheets.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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