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 average size of executables that you have created?
What is independent test group (itg)?
I am asked to create Usability testing methodology document, basically listing the Procedures & methodology to/for: a. Entry criteria Exit criteria for usability test b. Deliverables d. Methods of doing Reviews and inspection e. Methods of Reporting f. at which testing phase usability testing is done in v model Is there any sample document/template available on Internet? Any help will be greatly appreciated.
What is typically the most important reason to use risk to drive testing efforts?
What are the categories of debugging?
hi..I am from Pune and i want to take ISTQB.So pls tell me which book i should refer and sample papers?How much time i need to prepare for it?Those who have material pls help me out and mail me at pankaj_r_autela@yahoo.com , And those who are from Pune and have taken this exam ,i vl like to share your knowledge. Thanks in Advance to all of you.. Pankaj
What is the most critical component in SAN?
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
what is modular framework?
What is static analyzer?
Explain walk-through?
Mention the difference between data driven testing and retesting?
A type of integration testing in which software elements, hardware elements, or both are combined all at once into a component or an overall system, rather than in stages.
How can you eliminate the product risk in your project?
Functional testing?