+ Reply to Thread
Results 1 to 5 of 5

Data validation drop-down list - format

  1. #1
    Registered User
    Join Date
    11-30-2006
    Location
    UK
    MS-Off Ver
    Microsoft Office XP
    Posts
    61

    Data validation drop-down list - format

    Is there any way to change the font size of the entries in a drop down list generated by data validation?

    Jason

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Take a look at the attached link

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

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    11-30-2006
    Location
    UK
    MS-Off Ver
    Microsoft Office XP
    Posts
    61
    Thanks again,

    ------------------------------------------------------------------------
    Data Validation Font Size and List Length

    The font size in a data validation list can't be changed, nor can its default list length, which has a maximum of eight rows.
    ------------------------------------------------------------------------

    I am going to play with the VBA solution but I will not be able to use it.

    When you use workbooks within a network and do not have a digital signature, VBA, macros, script etc causes problems . Our ICT department is a bit strict, can't really blame them tho'

    Having said that, I really do appreciate the help

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No problem,

    The code should work ok on a network. Download the file from here

    http://www.contextures.com/DataValCombobox.zip

    VBA Noob

  5. #5
    Registered User
    Join Date
    11-30-2006
    Location
    UK
    MS-Off Ver
    Microsoft Office XP
    Posts
    61

    Talking Ouch! I smiled so hard it hurt!

    Thank you just doesn't really say it!!!!

    What other miracles can you perform?

+ 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