Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is SDLC and STLC? In analysis phase of SDLC, what exactly the testers will do?

0 Answers   Cap Gemini,


Non-functional system testing includes

1 Answers  


What determines the level of risk?

0 Answers  


There is very little time to test due to the development team delay how will you handle this situation?

0 Answers  


If you had 10 days to deliver the product but the Lead tells to deliver it in 6 days, then How and what Testing Techniques or Strategy you will follow inorder to deliver it in short time (6 days)

4 Answers  


What is Functional, Non-Functional, and Regression Testing used for (i.e. the purpose of each)?

0 Answers  


Explain static analysis?

0 Answers  


Can anyone provide the definitions for the following abbreviations? Thanx to anyone who could CIT CAP

0 Answers   CitiGroup,


What parameters to consider for Performance Testing?

6 Answers   Virtusa,


Can we use agil/scrum methodology in prodcut testing.

0 Answers  


What is memory leak and defect leak? Is there any harness testing? If yes, please explain?

0 Answers  


What is test tools?

0 Answers  


Categories