Consulting

Results 1 to 2 of 2

Thread: Increase the size of a validation list drop-down listbox?

  1. #1
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location

    Increase the size of a validation list drop-down listbox?

    Hey guys,

    I was wondering if there was a way to increase the size (or font) of the items in a validation list's listbox? I notice that the size changes with zoom (to give you a better idea of what I mean). I was wondering if there's either a setting in excel or a way I can programmitcally increase the size of this?

    The reason I ask is because if the sheet is at a zoom of, let's say, 65%...then the items in the validation listbox is even smaller, and difficult to read.

    Please don't ask why I have the view at 65%....it's not my workbook. This is a question a friend came to me with and I didn't have the answer for him. I suggested to just increase the zoom, but I am now curious to know if there is a way to do this without using zoom.

    BTW, font size increase does not help either. (I think I was going the wrong route to begin with, but I had to know )

    Thanks in advance!




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  2. #2
    VBAX Expert Shazam's Avatar
    Joined
    Sep 2005
    Posts
    530
    Location
    SHAZAM!

Posting Permissions

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