Hi, I am working on a tool I need help with a function of the tool, which I am not quite sure how to apply.
I have dropdown list in cell "E4" with different possible selections. I also have multiple listboxes. What I need help is making them visible based on
what is selected in the dropdown list. That also means that the listboxes shall be hidden or not visible by default and then made to be visible
by the selection.
I have dropdown list in cell "E4" with different possible selections. I also have multiple listboxes. What I need help is making them visible based on
what is selected in the dropdown list. That also means that the listboxes shall be hidden or not visible by default and then made to be visible
by the selection.
VBA Code:
'These are options of the dropdown list(cell:"E4"): Sales, Operations, Finance, IT, HR
private Sub ListBox1_Click()
"IT"
End Sub
Private Sub ListBox2_Click()
"Sales"
End Sub
Private Sub ListBox3_Click()
"Operations"
End Sub
Private Sub ListBox4_Click()
"Finance"
End Sub
Private Sub ListBox5_Click()
"HR"
End Sub