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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.