Hi Ashish,
Exactly what I wanted. Didn't know about the .TextFrame part.
Thanks!
Regards - Dave.
Date: Thu, 9 Jun 2011 11:10:06 +0530
Subject: Re: $$Excel-Macros$$ Application.Caller
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
below code will help you in extracting the text on images see if it helps you
Rectangle 1 , 5-Point Star 2 name of images or boxes
a = ActiveSheet.Shapes("Rectangle 1").TextFrame.Characters.Text
b = ActiveSheet.Shapes("5-Point Star 2").TextFrame.Characters.Text
On Thu, Jun 9, 2011 at 9:59 AM, Dave <davebonall...@hotmail.com> wrote:
Hi group,
I have 3 buttons on the worksheet which all fire the same macro. Each
button has different text, and the macro examins this text, and uses
it to run slightly differently depending on which button was used to
fire it. To obtain the text on the button, I use:
A = ActiveSheet.Buttons(Application.Caller).Characters.Text
The variable 'A' then holds the text.
But Excel buttons are a bit dull, so I was trying to brighten up the
sheet by using rectangles instead, which I can format as I please.
Although I could fire the macro from the rectangle, I couldn't find
the syntax to return the text within the rectangle. Anyone know the
syntax for this?
Regards - Dave.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Regards
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/
akoul.wordpress.com
My Linkedin Profile
P Before printing, think about the environment.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
