View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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