Jul 17 2021 05:52 AM
I have a worksheet that contains a 'button´ and a 'drop-down list'.
When the 'button' is clicked, it runs a macro that deletes the content of a set of specific cells.
When the drop-down list changes a different macro is run.
I need the drop-down list to run it´s macro and then to automatically run the macro that is attached to the button.
My instinct tells me that, even at my novice level, this should be easy to accomplish, but I cannot find a solution in HELP nor can I create one.
Would someone be kind enough to help me, please?
Many thanks ...
Jul 17 2021 05:57 AM
You can simply call the macro associated with the button from the macro associated with the drop-down list by inserting its name:
' Macro for the command button:
Sub ButtonMacro()
Range("D2:D50").ClearContents
End Sub
' Macro for drop-down list:
Sub DropdownlistMacro()
' Do some stuff
...
' Call the other macro
ButtonMacro
End Sub
Jul 17 2021 06:05 AM
SolutionJul 17 2021 06:05 AM
Solution