Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 defect?

0 Answers  


What is the main goal of defect prevention meeting?

0 Answers  


What is user documentation?

0 Answers  


At what phase tester role starts?

8 Answers   MBT,


What is software verification?

0 Answers  






What is the minimum criteria for white box?

1 Answers   TCS,


What is Multipath I/O?s

0 Answers  


What are the different Metrics followed in the project?

1 Answers   Cap Gemini,


HI to all this is dinakar i am planning to write istqb foundation level exam but i dont have the material so any one have material regards that one please send to my id was dinakarmails@gmail.com thanks alot in advance

0 Answers  


What are the two parameters which can be useful to know the quality of test execution?

0 Answers  


What is white box testing and list the types of white box testing?

0 Answers  


In a flat file there are multiple lines of records and each record have some values are there and each is seperated by a table. How can you upload these values into a table in SQL Server

1 Answers   CybAge,


Categories