Hello,
I am new to VBA and I'm looking to create a activeX ComboBox dropdown list where each value makes a different text text visible. My idea is to put 3 different texts and bookmark them with Text1, Text2 and Text3 and then when I choose 1 in the ComboBox, Text1 is visible while Text2 and Text3 are hidden. I'm looking to create an IF statement, something like "If ComboBox value is equal to 1, Text1 is visible while Text2 and Text3 are hidden" Is there any way to do this? I have managed to do it with the "non"-activeX combobox, but I would find it more suitable with the actievX ComboBox.

Here is what I done so far in the VBA script and I attach the file down below:



Private Sub ComboBox1_DropButtonClick()

ComboBox1.List = Array("1", "2", "3")

End Sub

Best regards

Attached Files

Dropdown.docm (21.3 KB, 8 views)