+ Reply to Thread
Results 1 to 10 of 10

Drop down list font size, Combo box, formula

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    Cambs
    MS-Off Ver
    Excel 2010
    Posts
    40

    Red face Drop down list font size, Combo box, formula

    Good afternoon,

    I'm new to this forum and looking for some much needed assistance.

    I've been trying to desperately increase the font size in a drop down list and through searching this site I am now aware that you can do so by creating a combo box (never used one before).

    My dilema is that the range of cells that I am looking up is located on a seperate sheet (All my data is referenced of this sheet) and the the combo box will need to be looked up for a formula on a further seperate sheet.

    Confused??? I am. Is this even possible?

    Help!!!

    Thanks in advance.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,281

    Re: Drop down list font size, Combo box, formula

    It sure is possible.


    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Drop down list font size, Combo box, formula

    See if this helps:

    http://www.contextures.com/xlDataVal08.html#Font
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    12-10-2013
    Location
    Cambs
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Drop down list font size, Combo box, formula

    Heres an example of the worrksheet.

    Thanks for all your help.
    Attached Files Attached Files

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,281

    Re: Drop down list font size, Combo box, formula

    I can't see any combo boxes on your sheet.

  6. #6
    Registered User
    Join Date
    12-10-2013
    Location
    Cambs
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Drop down list font size, Combo box, formula

    Sorry,

    I removed them because I couldnt get them to work and didn't know if what I wanted to do was possible with a combo box.

    Due to other sheets using them cells to pull information, I'm not sure if you can link a combo box with a formula?

  7. #7
    Registered User
    Join Date
    12-10-2013
    Location
    Cambs
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Drop down list font size, Combo box, formula

    PS,

    The two posts you are replying to are for the same excel sheet. ha ha. sorry to be a pain.

  8. #8
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,281

    Re: Drop down list font size, Combo box, formula

    Are you referring to DataValidation as the Combobox.

  9. #9
    Registered User
    Join Date
    12-10-2013
    Location
    Cambs
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Drop down list font size, Combo box, formula

    I believe what I already have is data validation, but this is what is not possible to alter font size etc so on researching all info seems to point to combo box. Never used these before and what I was hoping was to use a combo box as an alternative to solve the font size issue but I then have other sheets using formulae to pull information from cells which I have data validation currently in.

    So not to sure where to go with it really. But it is the same file where I am looking to hide cells if a cell - Saturday or Sunday.

  10. #10
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,281

    Re: Drop down list font size, Combo box, formula


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. change font size of drop down list
    By robert111 in forum Excel General
    Replies: 1
    Last Post: 12-08-2006, 12:24 PM
  2. [SOLVED] How can I enarge the font size in a drop-down list?
    By BobH in forum Excel General
    Replies: 2
    Last Post: 10-31-2005, 05:05 PM
  3. font size in a drop down list
    By kennedy in forum Excel General
    Replies: 1
    Last Post: 06-29-2005, 07:05 PM
  4. [SOLVED] Font size for in-cell drop-down list
    By John Simons in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-15-2005, 04:06 AM

Tags for this Thread

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