Run a macro after selecting a number from a drop menu?

[Margate]

Hello everyone!

I have made a drop down menu using Data / Validation / List. The list is very simple just containing numbers 1 to 22. What I want to do is once a user chooses a number from the list lets say number 5 I want a Macro named FiveDays to automatically run. I have tried and tried but to no avail! There will be 22 Macros in total (22 numbers on the drop menu). All that the macro is doing is hiding columns as if the length selected is 5 (5 days) I do not need / want 22 days to be displayed but only 5!

I am not the best in Excel but am learning and therefore need step by step instructions on this.

Thank you very much for any help

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.