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, 6 views)

I think I managed to find a solution for this, so if anyone is interested, here's my solution:


Private Sub ComboBox1_DropButtonClick()

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

If ComboBox1.Value = "1" Then
Bookmarks("Text1").Range.Font.Hidden = False
Bookmarks("Text2").Range.Font.Hidden = True
Bookmarks("Text3").Range.Font.Hidden = True
End If

If ComboBox1.Value = "2" Then
Bookmarks("Text1").Range.Font.Hidden = True
Bookmarks("Text2").Range.Font.Hidden = False
Bookmarks("Text3").Range.Font.Hidden = True
End If

If ComboBox1.Value = "3" Then
Bookmarks("Text1").Range.Font.Hidden = True
Bookmarks("Text2").Range.Font.Hidden = True
Bookmarks("Text3").Range.Font.Hidden = False
End If

End Sub