Is there any way to 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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks