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

words Mortal Combat, Street Fighter, Dead or Alive and Doom have in common?

3 Answers   EA Electronic Arts,


What are the different types of testing followed in your project, explain them.

2 Answers   Cap Gemini,


Explain what test deliverables is?

0 Answers  


What is class level methods?

0 Answers  


Explain Peer Review in Software Testing?

0 Answers   MCN Solutions,


Web 2.0 Style Software Testing Management System- any suggestions?

1 Answers  


Following questions were asked in amazon interview during written test for the post of Quality assurance engineer. Note. u can use any scripting language for 2nd 3 rd questions. Logic is important. 1.Write test cases for file transfer using bluetooth and IR in mobile… 2. Input = 193 the output should be displayed as 100+90+3. Write code without using inbuilt functions and procedures 3. string = performance and delimiter = r Write a code to display the output as Pe r For Man Ce Without using split function and inbuilt functions 4. please give correct test data for the remainder in the below program and also for the time TIME: DD MM YYYY HH MM SS Reminder: [ ] minutes

1 Answers   Amazon,


What are two formats of WWN defined by the IEEE?

0 Answers  


Explain test plan?

0 Answers  


I Want To Join Infrasoft Technologies,what is the Procedure To Join The Company?

0 Answers   Infrasoft,


Tell me about the risk-based testing.

0 Answers  


what is testing , why will be testing ,what is responsibilities of tester

3 Answers   Infosys, TCS,


Categories