Wild Card in button caption
 

Excel XP & Win XP
Bob Phillips & John Bundy helped me with capturing a Forms button caption,
but now I have another wrinkle in the problem. Most of the button captions
are multi-line so there is a Ctrl-Shift in the caption. I thought I could
get around that by using a wildcard symbol, something like:
If ShapeA.Caption = "Next*" Then
to get every caption with "Next" as the first word regardless of what
follows the "Next", but this is not picking up the right buttons. How can I
use the wildcard to select the right buttons? Thanks for your time. Otto

Wild Card in button caption
 

Otto,

see my follow-up in the other thread.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Otto Moehrbach" wrote in message
...
Excel XP & Win XP
Bob Phillips & John Bundy helped me with capturing a Forms button caption,
but now I have another wrinkle in the problem. Most of the button
captions are multi-line so there is a Ctrl-Shift in the caption. I
thought I could get around that by using a wildcard symbol, something
like:
If ShapeA.Caption = "Next*" Then
to get every caption with "Next" as the first word regardless of what
follows the "Next", but this is not picking up the right buttons. How can
I use the wildcard to select the right buttons? Thanks for your time.
Otto