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?
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.
Try this: ua-cam.com/video/vZGhjt2GFB8/v-deo.html in the step 5: "Place in this document” you will find "Type the cell reference" Write the cell reference there.
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?
That is possible. I made a tutorial on that also. Please check this: ua-cam.com/video/tt0Te20yiJY/v-deo.html Here i used image. You can create a button and use the technique i used in that video.
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??
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.
Hello sir I don’t how to explain I want something to be same as option to show me the classes i have, like a drop down list or combo box So when i click on it i can choose the class i want and it will show it to me in the same sheet and when i change to another class will be exist and still can change it in the sale sheet without effecting in the other class grades I am wondering if there is something like that Thank you
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...
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?
After you create and added code to your button on the first worksheet, Right click on the button and copy. Now go to every page and paste it. This will copy the button as well as the code. You'll be able to use the button on every page.
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?
it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed. Check here is the video: ua-cam.com/video/vZGhjt2GFB8/v-deo.html
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
You don't need to update macro every time however you'll have to save the file with .xlsm format and when you open the file you will have to click on enable content. If you want to work around it you'll have to setup your macro security according o your need. Details on macro security will he here: ua-cam.com/video/tXOcmM4GJB4/v-deo.html
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?
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 👍
By a given line i assumed specific cell. And it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed. Check here is the video: ua-cam.com/video/vZGhjt2GFB8/v-deo.html
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.
you can create a floating button ua-cam.com/video/Z6DhEF3VBos/v-deo.html but it will not move while scrolling. It will move after you've finished scrolling.
By specific place i assumed specific cell. And it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed.
At the top-right corner, select the Ribbon Minimize icon beside the minimize icon, If you are using newer excel versions. Now if you are using Excel 2010 then you'll have to Click on the small Up Arrow At the top right corner. Now if you are using Excel 2007 Then you'll have to Select "Customize Quick Access Toolbar". In the list, select "Minimize the Ribbon". Hope you got your answer. Thanks for the comment and please subscribe and share the channel. Thanks.
Place the cursor at the litter arrows at the bottom left corner of the sheet (Where you have the worksheets), right click there, you can see there is a context menu popping out to show first 15 sheets. If you have more then click more sheets and select the sheet from there. This is the shortcut. There is another option where you run a vba and write the sheet name and that sheet will open. if you need this let me know. And don't forget to subscribe
Follow the video instruction and create another button and change the worksheet name on the code. and repeat 30 times. But if you can wait i have another convenient solution. 30 buttons look awful in a worksheet. how about you select a sheet name from a drop down list and you'll be able to go to that sheet. i will upload the video and add the link here. Please subscribe and wait.
First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed.
I want to copy this button in every existing sheet of Excel so that from any sheet if I click that button then I reach to sheet1 Can you tell me the method , because I am copying this button manually on multiple sheet
Concise and straightforward explanation. Thank you!
You're welcome
It's really helped me today for my Excel Presentation. Love you my friend 👍♥️
Happy to hear that!
Thank u...your video make my life so easy...
Glad to hear that. It was an honor
Thanks man Very helpful !
Glad it helped! Please subscribe and be with us
THANKS a lot my friend!!!you help me so much!!!!
Glad to hear that!
Thank you very much. ❤
Most welcome. Please subscribe and be with us.
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. 😊
Good day, great video. Can show video on how to use button to specifically go to a cell in different sheet?
Yes, sure. Try this one ua-cam.com/video/vZGhjt2GFB8/v-deo.html write the cell number you need to go. check at the timestamp 1:15
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?
Excellent video
Thanks a million. Please subscribe and share with your friends.
Zabardast ❤❤❤
Thanks a million.
Thanks buddy very helpful
You are welcome. Don't forget to subscribe and share with your friends....
Thank you sir.
Most welcome
Thank you brother
Any time
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.
Just change the name in the code.
Thank for the video
You are welcome. Please subscribe
Hi can we make click button to go certain colum or area in different sheet
Try this: ua-cam.com/video/vZGhjt2GFB8/v-deo.html in the step 5: "Place in this document” you will find "Type the cell reference" Write the cell reference there.
can u plz show how to design and make this button look good in appearance
You can create buttons with shapes too
Thank you Buddy!!! Very Great!
Thanks for the comments buddy. Please share this video with your friends.
Hi, thanks for sharing!
Pls suggest after jump to desire sheet how do we can get back to the main sheet. Pls suggest 🙏
Create another button there.
@@Excel10tutorial thanks for your prompt reply sir!
Sir do we have undo command in VBA.
If yes, kindly guide
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?
That is possible. I made a tutorial on that also. Please check this: ua-cam.com/video/tt0Te20yiJY/v-deo.html
Here i used image. You can create a button and use the technique i used in that video.
Hi, could you please explain how to change the button shape
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??
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.
Haven't tried these.
Hello sir
I don’t how to explain
I want something to be same as option to show me the classes i have, like a drop down list or combo box
So when i click on it i can choose the class i want and it will show it to me in the same sheet and when i change to another class will be exist and still can change it in the sale sheet without effecting in the other class grades
I am wondering if there is something like that
Thank you
Will this work? ua-cam.com/video/MuKT6jF3hEY/v-deo.html
Awesome! Thank you!!
You're welcome!
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...
THANKS YOU!!!!!
You're welcome
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?
After you create and added code to your button on the first worksheet, Right click on the button and copy. Now go to every page and paste it. This will copy the button as well as the code. You'll be able to use the button on every page.
quick legend
Thanks
Hype. Thank you dude
You're Welcome. Please share and subscribe.
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?
it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed. Check here is the video: ua-cam.com/video/vZGhjt2GFB8/v-deo.html
@@Excel10tutorial You are a rockstar and yes, I am one of your subscribers. Amazing job. Keep it up.
Thanks for your appreciation.
please advise how i can have more than one button on first sheet that will command to go to respective sheets upon clicking ?
Create button and assign code to each button. Make sure you match the button name in the code.
Thank u!!!
You're welcome!
Is there any way to create a button that will generate a copy of an existing hidden sheet in the work book?
Very good like the tutorial, is it possible to create a sort button to a different sheet?
You can use slicer for that.
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
You don't need to update macro every time however you'll have to save the file with .xlsm format and when you open the file you will have to click on enable content. If you want to work around it you'll have to setup your macro security according o your need. Details on macro security will he here: ua-cam.com/video/tXOcmM4GJB4/v-deo.html
but i want to put sheet 3 in that button means that sheet 3 open in sheet 1 when i click that button
You can use vba listbox for that.
@@Excel10tutorial you have any video about that??
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?
It is possible. You need to refference that cell in the code.
Can u put a password on each sheet and unable them to view if password is incorrect
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 👍
By a given line i assumed specific cell. And it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed. Check here is the video: ua-cam.com/video/vZGhjt2GFB8/v-deo.html
@@Excel10tutorial A pleasur for me to be part of your community. Keep it up and thank you again for sharing your knowledge
Glad to hear that. Thank you very much for your comment.
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.
How to create the button that I can scroll down the sheet that the button drags with.?
you can create a floating button ua-cam.com/video/Z6DhEF3VBos/v-deo.html but it will not move while scrolling. It will move after you've finished scrolling.
How To Go to Specific Worksheet Based On Dropdown Lists In Excel: ua-cam.com/video/q2Cvk6a0Rus/v-deo.html
Taiyyab 👨💻👨💻🧾✒️✏️
@@tayyabcaisslc5893 Signup and code will be sent to your email.
Tq bro. May i know how to create a button to go to previous sheet?
I'll look into it and inform you soon. Please subscribe and share with your friends....
Hi Bro.. I am getting "Subscript out of range" error
You are using wrong sheet name. Check your worksheet name. make sure you are not missing anything from the code.
tell me please how to make this button take you to particular place inside the sheet ?
By specific place i assumed specific cell. And it is possible to do it with button. First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed.
Sir i want to add many buttons on 1 sheet for all sheet i want to go
What to do
These idea not working bocz there in going in only one sheet
Use the same procedure multiple times for multiple buttons. Also there are lot of tutorials in this channel for sheet navigation. Please check them.
How to excel sheet fuill screen make sir
At the top-right corner, select the Ribbon Minimize icon beside the minimize icon, If you are using newer excel versions. Now if you are using Excel 2010 then you'll have to Click on the small Up Arrow At the top right corner. Now if you are using Excel 2007 Then you'll have to Select "Customize Quick Access Toolbar".
In the list, select "Minimize the Ribbon".
Hope you got your answer. Thanks for the comment and please subscribe and share the channel. Thanks.
Onse make fuil scree then how to lock bro
Which Version? What types of lock? Protect sheet? I guess you gotta lock before you make it full screen.
Please send your mail ID bro
You'll find it in the channel about section and you can also contact us through our facebook page.
i have many sheets in one excel file how can i directly open particular sheet ( shortcut pls )
Place the cursor at the litter arrows at the bottom left corner of the sheet (Where you have the worksheets), right click there, you can see there is a context menu popping out to show first 15 sheets. If you have more then click more sheets and select the sheet from there. This is the shortcut. There is another option where you run a vba and write the sheet name and that sheet will open. if you need this let me know. And don't forget to subscribe
Here goes the video: ua-cam.com/video/PoTZMoRcYlU/v-deo.html
@@Excel10tutorial thanking you
@@raakshs3380 You're welcome.
wow its so nice , ,thank you ..
Isn't that obvious? If you change the sheet Name change the code.
@@Excel10tutorial if my sheet name is - monthly data
Thn what code will be
ThisWorkbook.Sheets("sheet3").Activate
@@sudiptadatta439 ThisWorkbook.Sheets("monthly data").Activate
@@Excel10tutorial thanks ❤️
You're welcome
how can i use Notepad during this time .....
Please Tell me in details what you need. Using notepad has nothing to do with excel.
I have 30 sheets in my excel. How can I set buttons for all sheets. As per your video you have set only one. Please reply
Follow the video instruction and create another button and change the worksheet name on the code. and repeat 30 times. But if you can wait i have another convenient solution. 30 buttons look awful in a worksheet. how about you select a sheet name from a drop down list and you'll be able to go to that sheet. i will upload the video and add the link here. Please subscribe and wait.
Thank u for the prompt reply. Awaiting for the videos
@@geethusatheeshbk You're Welcome
@@geethusatheeshbk Here it goes: How To Go to Specific Worksheet Based On Dropdown Lists In Excel: ua-cam.com/video/q2Cvk6a0Rus/v-deo.html
where to find developer in menu
Here: ua-cam.com/video/vUAO_nVE624/v-deo.html
Thanks boi
You're welcome.
How can i create a button to go to a specific cell?
First create a button from Inset-Shapes and then write the name of your button. Now right click on the button and click on the link. Select place in this document. Select the sheet name and write the cell no/name and click Ok. Done. Thanks for the comment and hope you subscribed.
I want to copy this button in every existing sheet of Excel so that from any sheet if I click that button then I reach to sheet1
Can you tell me the method , because I am copying this button manually on multiple sheet
Not come errors no9 appear
Code not clear kindly send
Signup here to get the code: forms.gle/H27wWWztmm6ezQZv6