Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of ComboBox on Custom CommandBar
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of ComboBox on Custom CommandBar
Application.CommandBars.FindControl(Tag:="cbo_tag" ).Text
if the tag property was used. "Kevin" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of ComboBox on Custom CommandBar
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 -----Original Message----- Application.CommandBars.FindControl(Tag:="cbo_tag ").Text if the tag property was used. "Kevin" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of ComboBox on Custom CommandBar
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 "Kevin" wrote in message ... 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 -----Original Message----- Application.CommandBars.FindControl(Tag:="cbo_tag ").Text if the tag property was used. "Kevin" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of ComboBox on Custom CommandBar
Tim,
This works exactly how I want it to- thank you for your help and follow through! Take care, Kevin -----Original Message----- 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 "Kevin" wrote in message ... 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 -----Original Message----- Application.CommandBars.FindControl (Tag:="cbo_tag").Text if the tag property was used. "Kevin" wrote in message ... 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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to exchange Custom Commandbar buttons between PC's? | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
commandbar | Excel Programming | |||
Moving CommandBar using VBA or C# | Excel Programming | |||
Add control to commandbar | Excel Programming |