Value of ComboBox on Custom CommandBar

K

Kevin

I've created a custom commandbar that has a combobox and
a button. I want to be able to choose a value from the
combobox, click the button, and have that run a macro
based on the value that is in the ComboBox. Does anyone
know how to return this value?

Thanks for your help!
Kevin
 
T

Tim Zych

Application.CommandBars.FindControl(Tag:="cbo_tag").Text

if the tag property was used.
 
K

Kevin

Tim,

Thanks for the help. I've never used the tag property
before, but I'll look into that and try to make this work.

Thanks again,
Kevin
 
T

Tim Zych

So when you create the combobox:

With .Controls.Add(Type:=msoControlComboBox, Temporary:=True)
.AddItem "something"
.AddItem "something else"
.OnAction = "MyMacro"
.Tag = "cbo_tag"
End With
 
K

Kevin

Tim,

This works exactly how I want it to- thank you for your
help and follow through!

Take care,
Kevin
 
Top