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

2, 6, 12, 20, 30, ___, 56

8 Answers   EA Electronic Arts,


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

0 Answers  


hi frens, i need ur help if nebody had worked or workin on online banking projects n online job portals ..frens cud u pls gimme the realtime examples for critical bugs, high severity n low priority bugs high severity n high priority bugs low severity n low priority bugs high severity n low priority bugs related to banking n job portal

0 Answers  


There are two sand clocks(timers) one complete totally in 7 minutes and other in 9-minutes we have to calculate with this timers and bang the bell after completion of 11- minutes!plz give me the solution.

6 Answers   Oracle,


What is quality circle?

0 Answers  


what does team player mean to you?

1 Answers   Convergys,


What are non-functional requirements?

5 Answers   Ford, Siemens,


Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?

0 Answers  


how can we identify a bug is because of s/w error or OS problem?

1 Answers  


What is boundary value testing?

0 Answers  


wht is release management . did the tester will involve in the release management

3 Answers   TCS,


Mention the difference between data driven testing and retesting?

0 Answers  


Categories