Vba which button was clicked

Learn how to remove unwanted space characters from text data in Excel using various methods. It's often the case that workbooks get very large and end up with a lot of I started making videos to go along with my post on pivot tables called Get The Latest News.

Follow Us Follow us on social media to stay up to date with the latest tips in Excel! Any help would be appreciated. Cheers Phil. Excel Facts. Format cells as time. Click here to reveal answer. Shift 2 is the sign. Joined Aug 5, Messages 12, Hi Phil, turns out that if you are using Buttons from the Forms toolbar , Caption isn't a property. This worked for me, with a button called Button1: Code:. Print ActiveSheet. Shapes "Button 1". Text End Sub. Joined Feb 10, Messages 11, SydneyGeek said:.

Click to expand Thanks Guys. The key object was 'Application. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 2. Related Hot Network Questions. Question feed. I wish button to appear always in last row of the last added person. For simplicity I think it is better to have like empty forms in the sheet but all invisible at the begining.

Then when user clicks add next member I simply make next rows visible, and move button to next person. But to do that I need to know my current position. If you have only one button for any one page, you can just get the ActiveSheet property, and it will be the button on that page. I finally found the solution for determining which button in a Worksheet was pushed. Since you have a macro wired to your button s , I assume you know which button it is that was clicked. To get the location of the button, use this:.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 1 month ago. Active 2 years, 1 month ago. Viewed 98k times. I have assigned macro to few buttons.

How can I find out inside macro which button was clicked? I am doing as user form, where he can input peoples from family: name1: surname1: name2: surname2: add next member I wish button to appear always in last row of the last added person.