Assign 4 macros to a single button depending on a value of another cell

Hello,
I need some guidance on creating my doc.

As a short introduction:
I have 2 sheets: Sheet1 and Sheet2.
On sheet 1 cell 2B I have a dorpdown List with values from Sheet2 A2:A5. The options in the dropdown list are called 1,2,3,4.
On Sheet 1 I have a button that has a macro assigned to copy cells from Sheet 2 underneath it.

For now I have assigned macro 1 for this button.

I have 4 macros created for each Cell value on cell 2B (1,2,3,4) in order to copy the certain Cells from Sheet2.
How do I make the button to perform macro1 if cell b2 has value 1, macro 2 if cell b2 has value 2, macro 3 if cell b2 has value 3 and macro 4 if cell B2 has value 4?

Below is the code with all the 4 macros:

Please Login or Register  to view this content.

I have also attached the document.

Thank you!hideunhide cells project.xlsm

Hi, detrimental,

please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure.

Ciao,
Holger

Hi, detrimental,

I have reduced the code to use an event behind Sheet1 monitoring Range B2 and work accodingly.

Code goes behind the Sheet, right-click on worksheet Tab and choose View Code, paste code into the code window:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, detrimental,

use the Copy command like this:

Please Login or Register  to view this content.

Ciao,
Holger