O
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 & 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