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
Explain failure?
The purpose of which is to allow specific tests to be carried out on a system or network that resembles as closely as possible the environment where the item under test will be used upon release?
What is black box testing? What are the different black box testing techniques?
Mention the difference between data driven testing and retesting?
Hi, I want to write ISTQB exam. Can anybody send me the material regarding this.
Explain the requirements?
What is software requirements specification?
How to write an implementation plan for our QA system with small budget, from scratch.
Explain exit criteria?
What is the information that should be covered in test plan?
What is considered to be a good test?
what is system testing?
What is software verification?
Explain compatibility testing?
Test report?