VBA Encyclopedia
To update on new Automation Techniques using Excel,Ms Access, SQL Server, Power BI and ASP.Net
Wednesday, October 2, 2013
Extracting Button Caption on a Click Event of a Button
'Assign this macro to button
Sub test()
MsgBox ActiveSheet.Buttons(Application.Caller).Caption
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment