+ Reply to Thread
Results 1 to 5 of 5

Dropdown list options

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    Dropdown list options

    I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?
    Last edited by Back2Basics; 02-10-2009 at 10:04 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Dropdown list options

    You can't really... but here are some tips/tricks that might help...

    http://www.contextures.com/xlDataVal08.html#Larger
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    Re: Dropdown list options

    I'm not really sure how marcos work in excel.

    I went to visual basics i excel, added a module and pasted the code that you directed me to.

    but this didn't work, is there anything special that I have to do?

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Dropdown list options

    did you follow the instructions on inserting the code?

    You have to right-click the tab for the sheet you are applying the code to and select View Code.. then paste the code in the editor there.

    In the code you will need to change the reference of the target address (i.e. $A$2) to the location your drop down cell is at.

  5. #5
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    Re: Dropdown list options

    thanks for the help

+ 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