Macro select based on Drop Down Selection

  • I am trying to have three actions (separate macros) to run based on a control button so that firstly select from the named drop down list, then push the control button linked to a macro which will look at the named selection and then based upon that selection run the associated macro.
    My drop down list is in a cell named "Choice", the data validation options are "First", "Second" and "Third" and the associated actions/macros are simply colour cell background, insert some simple text and put a border around cell.
    The names of the macros are Background, Text and Border again respectively.
    I have tried the following code with no success and would warmly welcome benefiting from the knowledge and experience of this forum
    Many thanks


    Code
    Sub CaseSelect()
    Select Case Range("Choice")
    Case ("Choice") = "First"
    Call Background
    Case ("Choice") = "Second"
    Call Text
    Case ("Choice") = "Third"
    Call Outline
    End Select
    End Sub
  • Re: Macro select based on Drop Down Selection


    Pike you're a legend, both have functionality I was looking for - many thanks, you're a legend.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!