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
Hi can anyone guide me regarding how the interview procedures will be in exterro Inc, Coimbatore
What is v&v?
What is system simulation?
What is compliance testing ?
What is quality circle?
Which is the current formal world-wide recognized documentation standard?
The Following Characterstics posses some XYZ company. * Uses formal standards and policies * Conducts software inspections * Has advanced configuration management and change control * Uses CASE tools * Has a software engineering process group * Gathers metrics on process and quality * Requires that developers have formal software engineering training * Practices continued process improvement Based on aboue , Tell me which CMM Level is the company..? 1. Level 1 - Initial 2. Level 2 - Repeatable 3. Level 3 - Defined 4. Level 4 - Managed 5. Level 5 - Optimizing
give an example of unit test and integration test and system test and UAT test?
What is the dfd (data flow diagram)?
Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing.
What is a test closure?
What is test item?
What is test first design?
What is dynamic testing?
What is control structure testing?