Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Data validation drop-down text size (2000)

    How can I change the text size (and/or the box size) of
    the drop down box of data validation when a list is
    selected? The auto box presents a font size that is too
    small.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data validation drop-down text size (2000)

    Text size and font seems to be the same as for a cell note. No way to change it though.

    You can make it wider by changing the column width appropriately and make it appear larger by changing the zoom percentage. But that doesn't help if you need it to be at anything below 100%.
    You could also not use validation but use the combobox control from the control toolbox instead. Cumbersome, but it works.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Data validation drop-down text size (2000)

    Jan,

    There does not seem to be a way of changing the Data Vaildation text size, but cell comment size is linked to Tool Tip font set up which can be altered via the controll panel. (Display Properties, Appearance, Item = ToolTip). Unfortunately this has no effect on the Data Validation text properties.

    Andrew

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data validation drop-down text size (2000)

    Thanks.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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