D
Dan
Hi,
I have created a combobox on the drawimg toolbar (using code below - copied
from the Excel VBA help file).
How can I find what the selection on it, I would like to know if "First
Item" or "Second Item" is currently selected.
Many thanks,
Dan
Sub Craete_toolbar_Combo()
Set myControl = CommandBars("drawing").Controls _
.Add(Type:=msoControlComboBox, Before:=1)
With myControl
.AddItem Text:="First Item", Index:=1
.AddItem Text:="Second Item", Index:=2
.DropDownLines = 3
.DropDownWidth = 75
.ListHeaderCount = 0
End With
End Sub
I have created a combobox on the drawimg toolbar (using code below - copied
from the Excel VBA help file).
How can I find what the selection on it, I would like to know if "First
Item" or "Second Item" is currently selected.
Many thanks,
Dan
Sub Craete_toolbar_Combo()
Set myControl = CommandBars("drawing").Controls _
.Add(Type:=msoControlComboBox, Before:=1)
With myControl
.AddItem Text:="First Item", Index:=1
.AddItem Text:="Second Item", Index:=2
.DropDownLines = 3
.DropDownWidth = 75
.ListHeaderCount = 0
End With
End Sub