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 extractin
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, D
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(Applica
