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

I wanted a good defect tracking system and had selected one when one of my friends suggested Zephyr 2.0 being a good test management system that too with an integrated defect tracking tool. Would like to know from those who have used it whether Zephyr is a good investment?

1 Answers  


I need to learn everything I can about the SDLC. What is the best online resource?

0 Answers  


What are the goals in your career as Test Engineer if u join the new compnay

0 Answers   Cap Gemini,


what r the contents in defect reporting?

3 Answers   MBT,


How to write an implementation plan for our QA system with small budget, from scratch.

0 Answers  






What is the major problems you resolved during your testing process?

0 Answers   iGate,


content of test status report

1 Answers   Convergys,


How u r managing the time constraints in completing the project?

0 Answers  


What is difference between JBOD and RAID?

0 Answers   IBM,


Write a function Occurrences() in a language of your choice that takes in two strings. The first is a search string, and the second is a sentence. For example, running the function: Running Occurrences ("o", "Red Gate Software - Ingeniously Simple Tools") will output: Occurrences of 'o': 4 Occurrences ("at", "The cat sat on the mat") will output: Occurrences of 'at': 3 Sample Question 2: 2)Below is Notepad's File/Save dialog. a) If you were asked to test this dialog, how would you go about it? b) List various inputs you might place into the "File name" text field to test it.

0 Answers  


What is oo system testing?

0 Answers  


What is the difference between functional test type and navigation test type?

3 Answers   Value Labs,


Categories