Pass Commandbar.Control.caption to sub routine

Hi All,

I have a custom Commandbar addin with lots of my own macros built in.

I'm trying to pass a value to a routine and then action it but i can't sus it out.

here's the commandbar code (this works fine, but i would love to know how to pass the caption of the selected button instead of having to type "vbUpperCase")

Please Login or Register  to view this content.

So basically when i click on the "vbUppercase" button it runs the following (but doesn't work )

Please Login or Register  to view this content.

any help is really appreciated

thanks for taking the time to read it

StrConv does not take a string as the type argument, it takes an integer value (usually an enum, but you cannot pass the name of the enum value as a string)

Couple of things, vbUpperCase is a numeric constant rather than a text value.
Your argument is the same name as the function, StrConv.

You can pass an argument on the OnAction

Please Login or Register  to view this content.

Please Login or Register  to view this content.

But I think it would be better to use the Parameter property.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You could also use the ActionControl object to get the caption

Please Login or Register  to view this content.

Romper:

Cheers mate appreciate the info strange that it doesn't accept a string even though it's has a preficf of STR? pah i dunno lol.

Pope:
That worked a frickin treat mate appreciate it

thanks to both of you

StrConv = String Conversion
nothing to do with the type of argument it takes!

romper:

i can work out what the abbreviation means lol, but fair enough i get what your saying. ta mate

FYI i gave Romper some +ve feedback but it wouldn't let me add to your andy