How can I create button in excel and apply Macro to it?



How can I create button in excel and apply Macro to it?..

Answer / 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

More Testing AllOther Interview Questions

Explain what test plan is? What is the information that should be covered in test plan?

0 Answers  


What is Test Server?

1 Answers   TCS,


I’m a test services vendor looking for a test management system that helps me to perform productively. Can anyone help me with this?

1 Answers  


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.

0 Answers  


Hi do any one has dumps for ISTQB or ISEB exams for august or september exam 2013. Pleae mail qazwsx2631981@yahoo.co.in

0 Answers   ISTQB,


What is the common risk that leads to project failure?

0 Answers  


Explain a variable?

0 Answers  


If 12=4, 22=10, 32=21 then 42=__?

10 Answers   EA Electronic Arts,


26). how will know do written test cases are sufficient to validate application of functionality? 27). how will you prepare test data to validate input object? 28). explain defect status? 29). how will know whether the developer accepted you defects or not? 30). explain acceptance test? 31). explain when we stop testing? 32). explain scope of your project? 33). in which module you conducted testing? 34). explain defects which you found in that module? 35). if defect is not reproducible then what information you will provide to developer 36). if developer is not accepted your defect then what you will do?

0 Answers  


have u write any sanity testcases?

0 Answers   MBT,


What is defect analysis?

0 Answers  


When is a test considered to be successful?

0 Answers  


Categories