View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 134
Default 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


.



.