How can I create button in excel and apply Macro to it?
- 1 Answers
- 2989 Views
- I also Faced
- E-Mail Answers
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 are the benefits of independent testing?
Explain compatibility testing?
Can any of u help me... How to use Security below listed testing tools 1. XSS Probe 2. SQL Power Injector 3. CAL9000 I have to do security testing using these tools.But I do not have any knowlwdge on this. I am trying to work using Help doc, but use, not able to follow Pls do needful
Please Check out and Answer the Questions in Networking section. It's argent.
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.
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
Explain in a testing project what testing activities would you automate?
Mention what the difference between a 'defect' and a 'failure' in software testing is?
What is the most difficult problem you’ve found during testing?
In MSBI also we need to write test cases please tell me because iam new to msbi
What is gorilla testing?
I am planning to write a ISTQB Certification exam , i don't know about EXAM fee structures , please tell me the fee structure ? mail id: karthitkd.123@gmail.com
Explain Peer Review in Software Testing?
What is a method that attempts to reduce the complexity levels of aging legacy software? 1. Reengineering 2. Regression 3. Restructuring 4. Reusability 5. Reverse engineering
Explain performance testing?
