Dropdown coloured and bold text

  • Hi, my VBA code for dropdowns works fine except the text does not appear in the dropdown as coloured and bold as I would like. How can I make it coloured and bold, cheers.

    Dropdown reference cells code

  • You can't, I'm afraid.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Note that you still can't set different formats per item, if that's what you are trying to do.


    Also, activex controls on worksheets are best avoided if possible.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why