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

Define defect density.

0 Answers  


What is path analysis?

0 Answers  


What is test tools?

0 Answers  


is manual testing enough for 2+ yrs,does it need any tools

0 Answers  


Advantages of automation over manual testing?

1 Answers   TCS,






What are the benefits of independent testing?

0 Answers  


How you would allocate a task to team members?

0 Answers  


what would be the test plan for agile testing??

1 Answers  


What is the key difference between preventative and reactive approaches to testing?

0 Answers  


I am planning to write ISTQB Foundation level certification. If you have materials/Q&Q, kindly send to me. My mail id:jyoti.akella@gmail.com .Pls help me

4 Answers  


hi everyone i want to download test director,winrunner,qtp latest versions pls help me

0 Answers  


what is ISO?

6 Answers  


Categories