|
Buttons
Hi,
XL2003 I have some buttons on the Worksheet (from the Forms toolbar) which fire specific macros. Can VBA return (to a variable) the text of the button that fired it? Regards - Dave. |
Buttons
Application.Caller will give you the name of the button.
You can get the text using the name. Tim "Dave" wrote in message ... Hi, XL2003 I have some buttons on the Worksheet (from the Forms toolbar) which fire specific macros. Can VBA return (to a variable) the text of the button that fired it? Regards - Dave. |
Buttons
Hi Tim,
Thanks for your help. But still stuck. I have: A = Application.Caller B = ActiveSheet.Shapes(A).Characters.Text The first line is working. But the second line gives an error. Can you please point me to the right syntax? Regards - Dave. "Tim Williams" wrote: Application.Caller will give you the name of the button. You can get the text using the name. Tim "Dave" wrote in message ... Hi, XL2003 I have some buttons on the Worksheet (from the Forms toolbar) which fire specific macros. Can VBA return (to a variable) the text of the button that fired it? Regards - Dave. |
Buttons
see if this works for you.
A = Application.Caller b = ActiveSheet.Buttons(A).Characters.Text -- jb "Dave" wrote: Hi Tim, Thanks for your help. But still stuck. I have: A = Application.Caller B = ActiveSheet.Shapes(A).Characters.Text The first line is working. But the second line gives an error. Can you please point me to the right syntax? Regards - Dave. "Tim Williams" wrote: Application.Caller will give you the name of the button. You can get the text using the name. Tim "Dave" wrote in message ... Hi, XL2003 I have some buttons on the Worksheet (from the Forms toolbar) which fire specific macros. Can VBA return (to a variable) the text of the button that fired it? Regards - Dave. |
Buttons
Hi John,
Thanks! When I modified the button with the macro recorder turned on, the syntax used 'Shapes', But 'Buttons' works and Shapes doesn't, so pooh to the macro recorder, and hats of to you. Regards - Dave. "john" wrote: see if this works for you. A = Application.Caller b = ActiveSheet.Buttons(A).Characters.Text -- jb "Dave" wrote: Hi Tim, Thanks for your help. But still stuck. I have: A = Application.Caller B = ActiveSheet.Shapes(A).Characters.Text The first line is working. But the second line gives an error. Can you please point me to the right syntax? Regards - Dave. "Tim Williams" wrote: Application.Caller will give you the name of the button. You can get the text using the name. Tim "Dave" wrote in message ... Hi, XL2003 I have some buttons on the Worksheet (from the Forms toolbar) which fire specific macros. Can VBA return (to a variable) the text of the button that fired it? Regards - Dave. |
| All times are GMT +1. The time now is 01:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com