Req. Video to create buttons in Excel - Software Applications - MS Excel - TIK Share

Req. Video to create buttons in Excel


Samadhan Katkar

2013-08-10

Can anyone furnish me related video how to create  buttons in a worksheet & how to connect worksheets with the help of check buttons.

CA Pulkit Sharma

2013-08-10

Hi i will make a video on how to use insert buttons and use macro to shift between sheets.

Reply

Samadhan Katkar

2013-08-10

Thanks for your prompt reply.

Waiting for related video

 

Warm Regards,

Samadhan

Reply

CA Pulkit Sharma

2013-08-10

You have to wait for sometime for video.

Here is the excel tutorial with pictures(photos)

To insert the button click on developer Tab

developer tool

 

 

Than click on insert

Insert in Developer tool

 

Once clicked on insert you will see the buttons and other stuffs. Select Button or any other tool as per your requirement.

Excel form control

 

 

Once button is select you need to draw the button in excel

Once drawn button will apear as below and you can change the name of button.

Excel form buttons

 

 

Will soon update in forum regarding writing a macro to activate the buttons. The drawn button will have no use till macro is assigned to it.

Reply