+ Reply to Thread
Results 1 to 2 of 2

Change font style, size and colour of text in a combo box

  1. #1
    Registered User
    Join Date
    03-03-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2007
    Posts
    25

    Lightbulb Change font style, size and colour of text in a combo box

    Is there any way to change font style, size and colour of text in a combo box?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Change font style, size and colour of text in a combo box

    hi asmi. use ActiveX Controls instead of Form Controls. since you are able to create a combo box, i assume your Developer tab is there. go to Insert & select the Combo Box below where it's labelled ActiveX Controls. right-click on the Combo Box & choose Properties. you can change lots of things in there.

    for Font Style & Size click on the ... on the right of Font. for font colour, it's ForeColor. Choose Palette for more choices.

    the Input Range & Cell Link is a little different from Form Controls. it's called ListFillRange & LinkedCell. and you cannot click on the cell reference for it to appear. you have to type in something like:
    'Sheet1'!A1:A4

    to enable the Combo Box for use, click on the Developer tab -> Design (Make sure it's not orange)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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. How to using comma style without change font & font size
    By rameshtupe in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 01:19 PM
  2. How to change the font/font size in a combo box
    By brendas in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 04:00 PM
  3. [SOLVED] font is 10 pt:how do i change the font size in a combo box?
    By nkruppa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2005, 05:05 PM

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