Change Shape Color Based On Combo Box Selection

  • Hi all,

    I am trying to use a userform (Combo Box) to update my named cell "Aircraft1" then based on the value selected change the color of an object.

    The code works great if I manually enter the value in the cell "Aircraft1", however if the dropdown list selects the value the object does not update its color.

    Is there a way to update the cell via a combo box, and then have the VB code change the color of the object?

    Thanks in advance for any possible solution to my problem.

    This is my code:

  • Re: Combo Box To Udate Cell Value Then Perfrom Code Actions

    As you have found out, selecting from a validation list does not trigger a Change event. Controling the arrow's color is easiest when done at the same time as filling the cell.

  • Re: Combo Box To Update Cell Value Then Perform Code Actions

    I believe I follow what you are saying. I tried to run the code after re-naming combobox "Drop Down 357" to ComboBox1, but it never updates "Aircraft1" cell, nor changes the object "arrow1" color. Could this be because I have used the Excel Forms Combobox feature vice creating in VBA?

    Please pardon my VBA knowledge as I am trying to learn some basics here.

    Thanks again for any hlep on my problem.

  • Re: Combo Box To Update Cell Value Then Perform Code Actions

    The original post said that the combo box was on a userform. The code I gave should go in the code module for the Userform.

    If the dropdown is from the Forms Menu (not the Toolbox, that's a third kind of combobox.)
    Assign the combobox to this macro (after ajusting the names in the macro.)

  • Buenas!, estoy tratando de realizar la misma operacion , tengo experiencia en excel pero no en estos metodos.

    me podrías explicar el codigo que te funciono ?

    yo quiero hacer algo similar tener en el desplegable 3 palabras,


    2-En proceso

    3- sin intervencion

    al 1 aplicarle color verde

    al 2 amarillo

    al 3 gris.

    al elemento .shapes.

    pero no entiendo ... si alguien me da una mano genial ! gracias!

  • Welcome to the Forum

    Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.

  • royUK

    Closed the thread.