Wild Card in button caption

[Otto Moehrbach]

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

 

[Bob Phillips]

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)