How can I create button in excel and apply Macro to it?
Answer Posted / 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 View All Answers
What is the difference between test scenarios and test strategy?
Explain operational testing?
How will you log a Defect when you are in the process of executing a test case?
I. Requirements are formally reviewed. II. Requirements are formally approved. III. Requirements are placed under configuration control. IV. Requirements are implemented in code. Using the above statements, when are requirements considered baselined? 1. I and II 2. I, II, and III 3. I, II, III, and IV 4. I only 5. I, III, and IV
What is software failure?
Demonstrated system testing experience in a large on-line environment – with at least 2 years experience including Development of test strategies development of test plans • execution of tests according to plans • defect management • using industry tools (eg HP Quality Centre formerly 'Mercury Quality Centre' (Test Director) , and • experience in interrogating and querying SQL server and Mainframe dtabases using tools such as RC Update, BRIO, SQL Server Management Studio
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
Test report?
Explain what n+1 testing is?
What is the difference between the white box, black box, and gray box testing?
Explain exit criteria?
What is life cycle?
How to improve in english
what is system testing?
How the 2 wings and body of the butterfly model of test development is represented?