View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_4_] Tim Zych[_4_] is offline
external usenet poster
 
Posts: 58
Default 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