VBA macro to use a drop down list, and by the selection all related columns must show and the rest be hidden.

Wesley Butler 0 Reputation points
2024-01-09T10:18:16.6466667+00:00

I have an excel sheet that has a dropdown list within which there are 10 tasks.

Each task has specific columns that need to be filled in, so on selection of a task from the drop down list the associated columns must show and the rest must be hidden. The same must happen each time a new task is selected from the drop down and the associated columns must show, and the others should be hidden.

User's image

Microsoft 365 and Office Development Other
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.