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 structural testing?

0 Answers  


Hi All My name is Kiran Krishna, Can I know what are the basic testing scenarios that we need to include in the application that is hosted on the Clustered environment of weblogic 9.2 version. Oracle version is 9 OS : Window 2000 Basically I needs some General testing steps to test the hosted application . Please help me out and send me the suggestion at Kiran.Krishna@arisglobal.co.in or Kirank_k@yahoo.com

0 Answers  


Explain walk-through?

0 Answers  


IS TESTING NEEDED TO EACH&EVERY PROJECT CUMPULSORY OR NOT?

4 Answers   HCL,


What goes into a Test Summary? How would you write a Test Summary?

0 Answers  






What is quality assurance (qa)?

0 Answers  


what is the difference between verification and validation ?

7 Answers   IBM,


What all things you should consider before selecting automation tools for the aut?

0 Answers  


What is database testing? Can anyone give some scenariors where we perform databse testing? also, please quote some interview questions in this regard.

2 Answers   TCS,


What is loop testing?

0 Answers  


What are the preconditions or initial conditions before doing the Automation testing?

1 Answers   Virtusa,


What are non-functional requirements?

1 Answers   TCS,


Categories