How to create button to go to certain sheet in excel

How to create button to go to certain sheet in excel?

I will be using form control button to create a go to button in excel. This tutorial is demonstrated using Microsoft excel 2010.

Let’s Get Started:

Step 1: Open the workbook and click on developer tab

Step 2: Click on “Insert” and click on button (Form Control)

Step 3: Draw the button and click “New” In the Dialogue box

5: Click save.

Done.

NB. Write your preferred sheet name in “Sheet1”

-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------

Thanks for watching.

#excel10tutorial #excelbutton

If you like this tutorial, please subscribe to Excel 10 tutorial:

Checkout our Advance Excel Tutorial Playlist:

Checkout the Excel Case playlist:

Connect us on social media

[sternritter]

Concise and straightforward explanation. Thank you!

[MrMazo-cvhd]

It's really helped me today for my Excel Presentation. Love you my friend 👍♥️

[zaayedhasan]

Thank u...your video make my life so easy...

[ghunpkh]

THANKS a lot my friend!!!you help me so much!!!!

[yatinmaharaj]

Hey. I have a university project where I have to make an annuity calculator. I want to know how I can create an excel table that outputs the number of rows based on user input. For example, if you want to see how the investment grows over 50 years the table must show 50 rows of compounding and if the user selects 100 then 100 rows of compounding etc...

[shenanigan]

Hi! Can you please make a tutorial like this but the other (reference) sheets are hidden and will only show up when click. Thank you. 😊

[adhiyamanvk]

Hi, I need an help with this kind of button, say instance I have 500 employees I want to enter Emp code click on the button and below I need their details is that possible?

[mirnaraouf]

Hi, could you please explain how to change the button shape

[ramandeepsr]

How to make a macro file like in which only when I click that page will open and other pages will remain hidden and so on. So, the only the index page will show, and when I click on someone that will open and other remains hidden.

[thelegend]

Hi There, Do i need to keep updating the macro everytime i re open excel? I get the cannot run macro error even though the button works before exiting excel

[danmj]

Hey
Great video. I have one question though. Is it possible to instead of writing the tab name in the macro code, to take the name from a cell? Sort of like a seach field with a button?

[mxyunus]

Many thanks for the above video. Very informative and clear.
I have ave a question, is it possible to create a button in a same tab to reach the designated column?

[sushantpatle]

Sir, How to open a specific Sheet using userform checkbox and command button in VBA?? Means for each sheet there should be separate checkbox and only one button. Can you please help me on this??

[aaronsticht]

Is there any way to create a button that will generate a copy of an existing hidden sheet in the work book?

[MahSomething]

Good Night Sir.
I am trying to build a database for my daily use in Excell, but I am facing some dificults has i never programmed before, so I want to ask if i can use the same code you used to creat that bottun on VBA, to refer to some Combobox, example i want to writh something to a expecifiq Sheet, and everything i write after a choose the sheet box from the combox would the stored there. And if i choice another sheet from the combox this should store everything in the other sheet not the same. In other words choice to wich sheet the information is going to be stored (Its a Form). Thank you for the video e sorry for the long text and bad english.

[brikali]

Thank you for that interesting demonstration.
I do have a question, is it possible to to add an option that allows to reach a given line in the next sheet. Thanks in advance for your answer 👍

[parekharihant]

Hi thanks for such a informative video. Can further explain us that if sheet name we rename it and then want to creat button after it. How to modify this command in it.

[cindymm]

Is there another way to do without using assign macro? By using macro it has to save as xlsm file. Most template/ files has already designed as such. I see Excel shared template ie. diet journal there is built in 2 simple buttons to click on it to go previous and next worksheet which is simple n cool. the workbook is worked n saved as xlsx. May I know how to do it?

[zafarshaikh]

please advise how i can have more than one button on first sheet that will command to go to respective sheets upon clicking ?

[jow]

Many thanks! I have a file with 40+ sheets and each of them I want to add a button to go back to one main sheet, is there any shortcut than go to each sheets and repeat the action for 40+ times?