How can I create button in excel and apply Macro to it?
Answer Posted / rahul
In Excel 2003 and in earlier versions of Excel, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet.
In Excel 2007, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet.
Select any cell in the worksheet.
In versions of Excel that are for Microsoft Windows, right-click the option button, and then click Assign Macro.
In versions of Excel that are for Macintosh, press COMMAND while you click or press CTRL while you click, depending on your operating system version. Then, click Assign Macro.
In the Assign Macro dialog box, click the name of the macro that you want to assign to the option button, and then click OK.
When you click the option button, the macro will run.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is functional decomposition?
What is iso - international organisation for standardizationo?
Could reviews or inspections be considered part of testing?
What is depth testing?
What is the difference between test scenarios and test strategy?
How u r managing the staff unavailability?
What is storage array?
Explain path testing?
What is difference between validation and verification?
What is checksheet?
what are all the documents needs to be submitted as a part of test closure?
How to test documents in a project that span across the software development lifecycle?
can any one suggest best institute for SAP TESTING and scope in SAP TESTING
What is the difference between test matrix and traceability matrix?
There is very little time to test due to the development team delay how will you handle this situation?