Format the items in a combobox

  • Thread starter Thread starter 0000_AAAA_0000
  • Start date Start date
0

0000_AAAA_0000

Hi and Many Thanks!

Sub Country()
Dim Drpdwn As DropDown 'DropDown
Set Drpdwn = ActiveSheet.DropDowns("CBox1")
With Drpdwn
.RemoveAllItems 'Para Borrar entradas previas
.AddItem "FRANCE"
.AddItem "ITALY"
.AddItem "SPAIN"
.ListIndex = 1
End With
'IS IT POSIBLE TO CHANGE THE FORMATTING
'THE SAME WAY WE DO FOR
'ActiveCell.Font.Size = 25
'ActiveCell.Font.Bold = True
'BUT FOR THE ITEMS IN THIS COMBOBOX??????????
End Sub


PS: by the way, MANY THANKS, Tom Ogilvy!!!!!!!!!!!!
 
Not a dropdown from the Forms toolbar, but you can change the font (for all the
options) if you used a combobox from the control toolbox toolbar.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Macro to each item in Combo Box 0
cancel a combobox change 1
Don't add item in combobox ... 4
How to disable the "ESC feature" of a ComboBox? 1
Put items in combobox using VBA and toolbox 3
Add item to comboBox "form" from vba 1
ComboBox and select item 5
Add item to combobox in sheet 7

Back
Top