ActiveX ComboBox showing different texts based on value

Basse · #2 05-11-2022, 11:38 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adjust userform layout based on combobox selection	jrooney7	Word VBA	3	09-16-2018 07:23 PM
ActiveX Controls not showing when pasted from Word to Email Body	Skahtn	Word	1	09-06-2017 02:41 PM
Inserting a particular image based on a combobox selection	LeonieD	PowerPoint	2	06-27-2014 05:39 PM
how to populate textbox based on combobox selection in word	IvanGeorgiev	Word	1	02-21-2013 07:32 PM
how to populate textbox based on combobox selection in word	IvanGeorgiev	Word VBA	1	02-21-2013 07:28 PM