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
