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

Posted 3 years, 11 months ago by Samadhan Katkar


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

Posted 3 years, 11 months ago by CA Pulkit Sharma


Thanks for your prompt reply.

Waiting for related video

 

Warm Regards,

Samadhan

Posted 3 years, 11 months ago by Samadhan Katkar


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.

Posted 3 years, 11 months ago by CA Pulkit Sharma


Your Reply:

You need to be logged in to reply.