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
Test engineer?
I need to learn everything I can about Function, Non-Functional and Regression Testing. What is the best online resource?
what is automation testing process? What are the main steps invloved in it?
hi friends pls send to me any one have or guide me for model papers or previous papers of ISTQB certification exam foundation level
Faults found should be originally documented by whom?
What is path testing?
What is top-down strategy?
What is code review?
What is execution?
What is the common risk that leads to project failure?
HI friends, I am planning to take up foundation level ISTQB Certification exam in March. Anybody having the study materials and sample papers please mail sunkumaranr@gmail.com Thanks in Advance...
What is boundary value?
Mention what the meaning of breath testing is?
Explain walk-through?
How you will write test cases for integration testing?