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

What is test executive?

0 Answers  


What is flowchart?

0 Answers  


What is recovery/error testing?

0 Answers  


what is ISO?

6 Answers  


Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?

0 Answers  






What can be thought of as being based on the project plan, but with greater amounts of detail?

0 Answers  


What is the difference between debugging and testing?

0 Answers  


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  


Explain compatibility testing?

0 Answers  


Difference between the Web based and client server testing. Explain using example..

1 Answers  


What is exhaustive testing?

0 Answers  


What is a test harness?

0 Answers  


Categories