This is so beautiful!!! I also appreciate the fact that your English and accent are so understandable compared to others I cannot make out what they are trying to saying. Hu hu hu! I'm so happy I'm crying. Quick question: Why do you have to type "C" before "True"? And what does "C" mean?
Hi Frances, thanks so much. I really appreciate that. I have lived outside the US for 18 years, so I think it has been important for me to speak English without slang in order for people to understand me. The 'C' in MSOC stands for Component in the Microsoft Office Component library. I hope this helps and thanks so much.
What an excellent tutorial. I had great fun replicating it on my Mac with just two, rather than three tables. I didn't bother doing three, because I understand what you are doing.
Hi Bev, thanks so much for the comment and very well done. I have many other videos in which I think you will also enjoy. My last 8 videos I also create from scratch so I think you will enjoy that as well.
This is Mind blowing !!! Many Many thanks for this Randy !!! All my reports now have been superseded by this way of visualization !! i was exactly looking for this !!! Regards from India ...................
That is so great to hear. I am so glad you like it. Not to add more features, but if you liked this tab video check out this cell-based tab video (its even simpler, but maybe not as beautiful) th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
Hi Phil, it has just a bit, but not much, however I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
This was absolutely fabulous! Took awhile to get it going but once I did, it started coming together nicely. Only problem I have is now when I click on a tab, it pulls up the screen outside of where it should and I have to "pull it in" so to speak like you did in this video,(you had to slide it back over) but you had to only do it once, so I'm not sure what I'm doing wrong. But otherwise, it all worked. Thank you for such a detailed video
Hi Stephanie thanks very much. I am really glad you liked the training. You can automate the scroll, horizontally or vertically. So you may want to add a last line of code to pull the screen back to the column (or row) that you want. Something like this: Activewindow.Scrollrow=1 or Activewindow.Scrollcolumn = 1 Just change 1 to whatever column or row you want
@@ExcelForFreelancers Thanks! Already learned a lot following the tutorial and building along with you. I even came up with some of my own ideas for the interface and code. Thanks for the inspiration to learn and create :)) Thumbs up!!
Great, happy to help. (Also please check out this video where I do both Horizontal and Vertical cell-based tabs: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
Hi thanks so much I am glad you liked this. You may also like the Step By Step Wizard which includes a summary in which you can print here: th-cam.com/video/-AfBDqdwU8k/w-d-xo.html
Thank You SO much Randy for this lovely tutorial! I worked on this with some little changes and it went on just so seamlessly well with your incessant guidance. But I would like to know after making these tabs, how will I keep a track of Gen Info, Time and earning History for many employees. If I choose an employee name from Gen Info tab, the rest of the tabs could show all Time Clock and Earning related to that specific employee. Hope you get what I am saying. Would love to see your take on this. Thanks in advance mate!!!
Hi Kunalj, you can just use a drop down list of an employee above all the tabs. When a new employee is selected, all of their information is then filled it. I teach all of this in my Employee Manager Series on my channel here: th-cam.com/users/ExcelForFreelancers Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much Mark I am really glad you like it. I have other videos with cell-based tabs that is really cool as well (as opposed to shape-based tabs)
Hi and thanks yes you can, Please check out my Employee Manager series for this here: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html&ab_channel=ExcelForFreelancers I hope this helps and thanks so much.
Hello! it's beautiful so cool thank you for teaching us like this things. I also try it by myself but it doesn't work there are some debug with range don't show and hide it's declered like this "Method 'Range' of object'_Worksheet' failed what does it mean help me?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi mate what if I wanted to create a multiple taps section one below another I mean when I’m doing this for the first horizontal tab it’s ok but when I’m creating the next one it’s get so messy thanks for helping out :)
Hi thanks so much for your comment. You will want to make sure to plan this all out in advance since its harder to change once you have added the code. I have other ideas for tabs you may like right here: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Hi and thanks I use 'True' when checking to see if a shape is visible and msoctrue, which is the natural code for shapes, within Excel. This is just the basic rules as designed as far as i know. I hope this helps and thanks so much.
Randy!! TYSM for an amazing tutorial! Question though ... what if I want to print my workbook to present in paper form at meetings and such? (Yes, I work with folk that still like paper!). Am I correct in assuming I'm going to have to keep another bland copy on hand cause this beauty won't print in all its glory?
Hi and thanks Bindi. You can print anything and everything you want, however it may take some VBA code to do that, (since you might have to switch tabs in the Print macro) If you need help with this, I would be happy to refer you to a qualified developer. Randy@ExcelForFreelancers.com Thank you for your Likes, Shares & Comments. It really helps.
Hi I think its definitely possible when you pull data from a database. I have created a Facebook group with 5000+ Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
Thanks most of my videos are long these days. (Especially the current Employee Manager series, which are around 1 hour per video) I just get so excited to tech lots of new and cool tricks. Thanks so much for your comment.
That's pretty for sure. is there anyway to bring the data from sheet 2 or 3 (different sheet I mean) or they have to be in the same sheet that includes the tabs? Thanks in advance
Hi there are many ways to bring the data from other sheets. If it is a filtered data you can use an advanced filter, straight cell links or a value to value copy. I hope this helps and thanks.
@@ExcelForFreelancers Thank you for the amazing video and for this clarification. What am trying to tell you is that when I press on the tab Gen Info for instance, I want to bring the relevant data from another sheet and show it in the same sheet where the tabs are located. it seems to me that we need to edit the code itself to be for instance "with sheet2" instead of sheet1. I tried it but didn't work out. Thanks anyway, it is still very nice and useful video.
I there, you should be able to use scroll bars as long as the columns are hidden that you do not want displayed. Vertical scroll bars would not have any effect and you could freeze the top set of rows to keep the tabs visible. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Hi i am not sure what you mean. Can you please upload a screenshot in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel So that I and the other members can have a look and make suggestions. Thanks very much
I loved it and it will work great for me. What happens with the view when, for example, the Time Clock History increases in size to 20 lines and more? Thank you.
Hi thanks for your comment. There should be no issue since its only the columns that are hidden/shows. Rows are always displayed so there should be no issue at all with additional 20 or even 2000 lines, You may want to freeze the header so that the tabs are always displayed when you have a lot of rows.
Hi, you are very welcome. I am glad you liked this horizontal tabs tutorial. Feel fee to try out the Vertical Tabs Tutorial which is even easier here: th-cam.com/video/RkLD1AtF1Cw/w-d-xo.html
Thanks so much. IN 12 hours I plan to release a new video on both Horizontal and Vertical Tabs and I think you will love it. (This link will go live at 9/11/2018: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html )
Hi Randy, Thanks again very good presentation and very interesting way to present informations. I tried to use it and I have a problem. I have Excel 2019 and even if I change the properties to Do not move or Resize, my shapes are still moving when I scroll my sheet either up or down or left or right. I would have love to test your workbook, but I cannot download it. Do you know if there is a problem with Excel 2019…?? Thank you.
Hi Guy, thanks so much. the shape should not be moving however if you do not have enough visible area, meaning too many columns or rows are hidden, then it could still move. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
You can how rows, columns of course or you can hide specific contents of cells using a custom cell format of ;;; (3 semicolons) I hope this helps and thanks so much.
13:47 this part of your tutorial when you type the "With" then the "End With" is added automatically isnt that done with autohotkey?how can I get the code for that?
Ahhhhhh. Now i understand. Auto-Hotkey is the program I use, but the code must be added to Auto-hotkey script like this: #IfWinActive ahk_class wndclass_desked_gsk :b0:with::{Enter}{Enter}{Enter}End With{Enter}{up 2}{end} :*:then`n::Then{Enter}{Enter}End If{Enter}{up 2}`t :b0:select case::{Enter}{Enter}{Enter}End Select{Enter}{up 2}{end} :b0:do::{Enter}Loop{Enter}{up 2}{end} ::diml::Dim As Long{Left 9} ::dims::Dim As String{Left 11} ::dimr::Dim As Range{Left 10} ::dimd::Dim As Double{Left 11} ::lr=::LastRow = Range("A1").End(xlUp).Row ::Vbc:: & VbCrLf & " ::.r::.Range("").value{Left 8} ::ifn::If Not Intersect(Target, Range("H12")) Is Nothing ::apw::application.WorksheetFunction.Match(" These are just some, you can add your own as much as you want.
Hi! Great video. Is it possible to make it with many sheet from different workbook. Also I'm triying to seach and copying data from other workbook. Is it possible you help?
Hi thanks this is very possible and in fact my video being released tomorrow (6/12/2018) will show you how to connect data from another workbook, so I believe you will find it very helpful. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel
Hi and thanks you can run an If/Then statement then use the Hidden = true option to hide the columns. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
HI and thanks so much. A hospital management application would be a massive software however I to have one on a Clinic Manager here: th-cam.com/video/9oebyN-ivhU/w-d-xo.html I would consider a Pharmacy Manager in the future although i would have to understand more about the software. Thank you for your Likes, Shares & Comments. It really helps.
Hi Andy, Thanks for this great video! I have created my own report followed your instructions in the video and it is working good except a small issue when i apply "TabGen" Macro, it really hide/unhide the targeted columns but the Screen automatically - by default - shows the columns start from "W,X,Y....->" column so i have to go with row to left (the page beginning) and this make hassle with me. How we can we solve that :)
HI Mohamed, thanks for your feedback. I am really glad you like the training. You can automatically scroll to any row or column in VBA with lines of code like this: ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Hey Randy.Thank you so much for this wonderful video.!Could you please lend me a hand. I got everything in my tab like this working perfectly. Just dont know how can I force the file to stay on the interface. Just like what happened with you at 22:13 that you need to scroll a little just to go to the interface again.I've tried application go to range scroll true but no success. Thanks in advance!🙂🙂🙂
HI Carmela, Thanks very much for your comment and question. I am glad you like the video. You can use ActiveWindow.ScrollColumn = 4 to get the application to automatically scroll to a specific column. 4 would be column D. I hope this helps.
Hi, Yes it is. (I am changing email companies so this problem does not happen in the future) You can download this file from the following link: bit.ly/Horiz_Tabs
A very well explained video. Thank you Randy. Randy: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. Your help is greatly appreciated.
Yes, actually I have a course coming out in a month or two which shows exactly how to create drop down lists in Excel. Here is a quick 2 minute sample (no sound): bit.ly/DashSampleVid
Hi Randy, thanks for amazing tutorial. I've done it for 12 tabs (months), but I have a problem. When I'm changing the tabs one by one forward and backwards is ok but when I want to switch by 2 tabs backwards for example from March to January focus on the screen is outside the tables on empty space from cell FA to GA , last cell with the table is EZ. Could you please help on this one. I'm not sure what went wrong. Thank you.
Hi Kent, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Kent, yes for sure. If you email me (Randy@ExcelForFreelancers.com ) I can refer a developer to help you with this. I hope this helps and thanks so much.
Brilliant tutorial as always. I have a doubt, say the tables are present in Sheet 1 and the display with tabs is present on sheet 2, what changes will have to be made to create this model?
Hi and thanks you will just have to update the code to specify a sheet # when saving and loading data. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Amazing video. I have done this with 26 buttons. And all are working just fine. highly appreciated and thanks. I have just one query. Let me elaborate first. in this video, you have put the content into tabs from the same sheet, i mean the whole content was in a sheet. what if i want to put all my content into this tabwise format where these contents gotta be coming from different sheets? How do i write the code for that? I reckon this videos has been 5 years old, so if there is a chance that you might have already uploaded something that answers my query, would you please share the link? or help me anyway?
HI and thanks so much. I did create a video in which I had a tab system that actually hid columns to display contents all on the same sheet and the data was pulled from different sheets here: th-cam.com/video/5Bw7TZ0IJTo/w-d-xo.html I hope this helps and thanks so much.
@@ExcelForFreelancers i have another question if you dont mind. What if try this same procedure for verical tabs where i only have to place the shapes vertically instead of horizontally and keep the other things same as this video? Will that work?
Thanks A Lot Randy !!!!! This Is Great 👍 This tutorial help us lot. I have created the same macros for 22 tabs, almost everything is fine though I am experiencing bit glitch while jumping from last tab to first tab. Display shows unknown range of cells ( Similar as in this video @ 22:12, when you click on first tab its slide away ). Is there any solution to get rid of this issue. Many Thanks. :)
Hi thanks very much for your comment and liking the video. There could be a few reasons for this issue. Perhaps you can join our Excel For Freelancers Facebook Group here; bit.ly/groupexcel , then upload your screenshot and code so we can help you with the problem. Thanks so much.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
I was a little shocked how much you speak about color choices, but I realize how professional these choices make your sheet.
Thanks so much. Yes i think the look and feel is an important part of professional applications. I really appreciate your comment.
I love you, literally you are number and your all formats are number 1 in the world
Thank you so very much, I really appreciate that Sanntosh
@@ExcelForFreelancers can you please talk to me on WhatsApp
+918180011931 is my WhatsApp number
Please sir
This is so beautiful!!! I also appreciate the fact that your English and accent are so understandable compared to others I cannot make out what they are trying to saying. Hu hu hu! I'm so happy I'm crying. Quick question: Why do you have to type "C" before "True"? And what does "C" mean?
Hi Frances, thanks so much. I really appreciate that. I have lived outside the US for 18 years, so I think it has been important for me to speak English without slang in order for people to understand me. The 'C' in MSOC stands for Component in the Microsoft Office Component library.
I hope this helps and thanks so much.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Thank you so much this came in really handy for something I've been creating. A cool unique way to switch between forms!
Great, thanks so much and I am happy to help and share
Excellent. Superb. Simple and very creative idea. You make Excel like a kid's toys.
Thank you so very much, I really appreciate that.
What an excellent tutorial. I had great fun replicating it on my Mac with just two, rather than three tables. I didn't bother doing three, because I understand what you are doing.
Hi Bev, thanks so much for the comment and very well done. I have many other videos in which I think you will also enjoy. My last 8 videos I also create from scratch so I think you will enjoy that as well.
This is Mind blowing !!! Many Many thanks for this Randy !!! All my reports now have been superseded by this way of visualization !! i was exactly looking for this !!! Regards from India ...................
That is so great to hear. I am so glad you like it. Not to add more features, but if you liked this tab video check out this cell-based tab video (its even simpler, but maybe not as beautiful) th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
Wonderful video sir.. I have practiced on it. And the trick helping me to get my dashboard dynamic look.
Thanks again.
For sure you are very welcome. I am happy I can help.
I did 12 buttons and it all really worked❤️❤️
Wow great. Good job and thank you for your Likes, Shares & Comments. It really helps.
Honestly this video helped me alot .Thank you. it is very informative.
That is really great to hear. I am happy to help and share
Very nice tutorial.for the very first time i am able to understand the VBA...
Thanks very much. I am really glad you liked it.
Awesome video Randy ! Keep the great work !
Thank you very much. I do appreciate that Jerome
Nice work Randy. Top drawer yet again.
Thank you so very much, I really appreciate that Phil.
@@ExcelForFreelancers Does your course include the learning of VBA for beginners?
Hi Phil, it has just a bit, but not much, however I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Tank you so much. I enjoyed your video and created my own using.
Hi Salim,
Thanks so much. I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
Great tutorial. Thank you for this. I will be using this to improve my work going forward
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
You're a life saver!!! Thank you!!
Thank you so very much, I really appreciate that.
This is amazing and simple. You're great
Thank you so very much, I really appreciate that and I am happy to help and share
Thank you very much for the video. Everything works and it's cool.
Please tell me, how to make 10-20 copies of the Sheet with all settings saved?
HI and thanks. You can use the 'Save As' feature and just save it as a different name. I hope this helps and thanks so much.
Yeah !!! so good, and the tip about screen flashing, great !! Thx
For sure, you are very welcome
This was absolutely fabulous! Took awhile to get it going but once I did, it started coming together nicely. Only problem I have is now when I click on a tab, it pulls up the screen outside of where it should and I have to "pull it in" so to speak like you did in this video,(you had to slide it back over) but you had to only do it once, so I'm not sure what I'm doing wrong. But otherwise, it all worked. Thank you for such a detailed video
Hi Stephanie thanks very much. I am really glad you liked the training. You can automate the scroll, horizontally or vertically. So you may want to add a last line of code to pull the screen back to the column (or row) that you want. Something like this:
Activewindow.Scrollrow=1
or
Activewindow.Scrollcolumn = 1
Just change 1 to whatever column or row you want
@@ExcelForFreelancers Thank you! It worked like a charm. I appreciate it!!!
Thank you had the same issue and worked perfectly, really good tutorial cheers @@ExcelForFreelancers
Thank you so much I am looking for how to make tabs in excel from many day
Thank you once again sir ❤.
For sure, you are very welcome and I am happy to help and share
@19:07 - Off screen editing (You little cheat you...)
Nice idea and nice presentation, I got the 150 book and enjoying it so far.
K
Thanks so much. I am glad you liked the training (and caught the edit). I hope you enjoy the 150 workbook pack and thanks so much for your purchase.
Hi Randy. Awesome technique! Will study this further. Thanks for sharing it :)) Thumbs up!!
For sure, you are very welcome Wayne I am glad you liked this training.
@@ExcelForFreelancers Thanks! Already learned a lot following the tutorial and building along with you. I even came up with some of my own ideas for the interface and code. Thanks for the inspiration to learn and create :)) Thumbs up!!
For sure, you are very welcome Wayne, Happy to help
Very helpful. Thank for your video!
Thank you very much. I do appreciate that.
Thanks. Just what I'm looking for.
Great, happy to help. (Also please check out this video where I do both Horizontal and Vertical cell-based tabs: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
Thank you. You should include "VBA" in the title, more people would visit your videos. You explain the VBA code very well, line by line. Great!!
Excellent Idea. Thanks, I just made the change to the title :)
Simple yet effective. Thank you 🙏
You are very welcome, happy to help.
Great idea. Also, thanks for the HotKey tip. Works beautifully.
For sure, I am happy to hear that. Glad to help you :)
Nice lesson. Very useful. Thanks a lot.
Thanks so much. I am glad you like it.
Very nicely done! I wish my job had a use for this. I have to create and print documents.
Hi thanks so much I am glad you liked this. You may also like the Step By Step Wizard which includes a summary in which you can print here: th-cam.com/video/-AfBDqdwU8k/w-d-xo.html
Muy buen vídeo. Gracias por compartir. Cada día Se aprende más.
Graicias Mi amigo Alvaro
Many Thanks, it was very useful and great help please keep up with these great videos
Thanks so much, I am really glad you like them.
Thank You SO much Randy for this lovely tutorial! I worked on this with some little changes and it went on just so seamlessly well with your incessant guidance. But I would like to know after making these tabs, how will I keep a track of Gen Info, Time and earning History for many employees. If I choose an employee name from Gen Info tab, the rest of the tabs could show all Time Clock and Earning related to that specific employee. Hope you get what I am saying. Would love to see your take on this. Thanks in advance mate!!!
Hi Kunalj, you can just use a drop down list of an employee above all the tabs. When a new employee is selected, all of their information is then filled it. I teach all of this in my Employee Manager Series on my channel here: th-cam.com/users/ExcelForFreelancers
Thank you for your Likes, Shares & Comments. It really helps.
Always top application thank you Mrs Excel
For sure, you are very welcome Messaoud
Thank you for a great tutorial. This is an excellent way to present data in a compact form.
Thanks so much Mark I am really glad you like it. I have other videos with cell-based tabs that is really cool as well (as opposed to shape-based tabs)
Just too good. Enjoyed watching this.
Thanks so much Awesh, much appreciated.
This is just fabulous sir, Thanks a Lot
Thank you so very much, I really appreciate that Anirudh
Thanks for the tutorial. Just finished my work using this cool idea. 😎👍
For sure, you are very welcome I am glad I could help
Thanks for sharing this man....Been looking for a way out with my CMDB on Excel
For sure no problem, happy to help
The best tutorial so far. Thank you.
Thanks so much Gurong, I am so glad you like it. Here is another way to do tabs that you might like: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
Thanks for the tutorial!
For sure, you are very welcome I am happy to help.
You are excel god love from India
Thank you so very much, I really appreciate that :)
Can you search by name on the general form so the tabs display per employee?
Hi and thanks yes you can, Please check out my Employee Manager series for this here: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html&ab_channel=ExcelForFreelancers
I hope this helps and thanks so much.
Thanks a lot... such a nice tutorial....Great Job Bro..
For sure, you are very welcome
Great explanation 👍👍. Thank you very much.
For sure, you are very welcome.
Hello! it's beautiful so cool thank you for teaching us like this things. I also try it by myself but it doesn't work there are some debug with range don't show and hide it's declered like this "Method 'Range' of object'_Worksheet' failed what does it mean help me?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Thanks a lot Randy Sir....
For sure, you are very welcome
Hi mate what if I wanted to create a multiple taps section one below another I mean when I’m doing this for the first horizontal tab it’s ok but when I’m creating the next one it’s get so messy thanks for helping out :)
Hi thanks so much for your comment. You will want to make sure to plan this all out in advance since its harder to change once you have added the code. I have other ideas for tabs you may like right here: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
For the shapes, is there a specific reason you use msoCTrue as opposed to msoTrue in the macros?
Hi and thanks I use 'True' when checking to see if a shape is visible and msoctrue, which is the natural code for shapes, within Excel. This is just the basic rules as designed as far as i know. I hope this helps and thanks so much.
Thank for sharing the information.
For sure, you are very welcome
Excellent video, thank you very... very much!!!!!!
For sure you are very welcome Nuno
great job and video, thanks for sharing this info
Thanks so much Jack. I do appreciate that
Randy!! TYSM for an amazing tutorial! Question though ... what if I want to print my workbook to present in paper form at meetings and such? (Yes, I work with folk that still like paper!). Am I correct in assuming I'm going to have to keep another bland copy on hand cause this beauty won't print in all its glory?
Hi and thanks Bindi. You can print anything and everything you want, however it may take some VBA code to do that, (since you might have to switch tabs in the Print macro)
If you need help with this, I would be happy to refer you to a qualified developer. Randy@ExcelForFreelancers.com
Thank you for your Likes, Shares & Comments. It really helps.
Nice work...Very Helpful...Thank you
Of course, you are very welcome. Happy to help.
Hi I think its definitely possible when you pull data from a database. I have created a Facebook group with 5000+ Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
Excel For Freelancers thank you for quick response and FB link. I have joined and will explore
you think the video is long? well i am going to watch over again. very insightful. thank you
Thanks most of my videos are long these days. (Especially the current Employee Manager series, which are around 1 hour per video) I just get so excited to tech lots of new and cool tricks. Thanks so much for your comment.
Thanks i have learn something new here.....TQSM
For sure, you are very welcome.
That's pretty for sure. is there anyway to bring the data from sheet 2 or 3 (different sheet I mean) or they have to be in the same sheet that includes the tabs? Thanks in advance
Hi there are many ways to bring the data from other sheets. If it is a filtered data you can use an advanced filter, straight cell links or a value to value copy. I hope this helps and thanks.
@@ExcelForFreelancers Thank you for the amazing video and for this clarification. What am trying to tell you is that when I press on the tab Gen Info for instance, I want to bring the relevant data from another sheet and show it in the same sheet where the tabs are located. it seems to me that we need to edit the code itself to be for instance "with sheet2" instead of sheet1. I tried it but didn't work out. Thanks anyway, it is still very nice and useful video.
Please see my Employee Manager series here on TH-cam for samples on how to do that.
wow Thank you so much for all your time and effort.
For sure Luis, Glad I can help. Thanks for your comment.
Great work
Thank you very much
Thanks very much. Happy to create them for you Shahroze
Great tutorial. But how can we use scroll bars on each tab results?
I there, you should be able to use scroll bars as long as the columns are hidden that you do not want displayed. Vertical scroll bars would not have any effect and you could freeze the top set of rows to keep the tabs visible. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Thanks for your time to answer. But i mean is, the scroll bars which can be used in the result sheet to show.
Hi i am not sure what you mean. Can you please upload a screenshot in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel So that I and the other members can have a look and make suggestions. Thanks very much
excellent tutorial sir
Ketan Baria Thanks so much I really appreciate that
I loved it and it will work great for me. What happens with the view when, for example, the Time Clock History increases in size to 20 lines and more? Thank you.
Hi thanks for your comment. There should be no issue since its only the columns that are hidden/shows. Rows are always displayed so there should be no issue at all with additional 20 or even 2000 lines, You may want to freeze the header so that the tabs are always displayed when you have a lot of rows.
Thank you! This video was very helpful in helping me write my first Macro!
Hi, you are very welcome. I am glad you liked this horizontal tabs tutorial. Feel fee to try out the Vertical Tabs Tutorial which is even easier here: th-cam.com/video/RkLD1AtF1Cw/w-d-xo.html
Thank you, sir, your way of teaching is awesome and appreciable
Thank you so much Sameer. I do appreciate that.
Great Video! Very helpful.
Thanks so much. IN 12 hours I plan to release a new video on both Horizontal and Vertical Tabs and I think you will love it. (This link will go live at 9/11/2018: th-cam.com/video/iyr9WIyxlJc/w-d-xo.html )
Amazing work sir....
Thank you very much.
you are a MASTER!
Thank you so much Rodolfo
thanks buddy!! learned a lot
For sure, you are very welcome. I am glad you liked it.
Hi Randy,
Thanks again very good presentation and very interesting way to present informations.
I tried to use it and I have a problem. I have Excel 2019 and even if I change the properties to Do not move or Resize, my shapes are still moving when I scroll my sheet either up or down or left or right.
I would have love to test your workbook, but I cannot download it. Do you know if there is a problem with Excel 2019…??
Thank you.
Hi Guy, thanks so much. the shape should not be moving however if you do not have enough visible area, meaning too many columns or rows are hidden, then it could still move. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Excellent video Randy. Is there any way we can hide specific set cells instead of entire columns?
You can how rows, columns of course or you can hide specific contents of cells using a custom cell format of ;;; (3 semicolons)
I hope this helps and thanks so much.
Excelente, es usted un maestro, gracias por el vídeo
De Nada Mi Amigo :)
This is very convenient!
Great, thanks so much
This is super awesome.
Thank you so very much, I really appreciate that.
do you have a video for how you create the hotkey automation or the software that does it?
Hi Wayne, Thanks very much for your comment. I do not have any hotkey automation.
13:47 this part of your tutorial when you type the "With" then the "End With" is added automatically isnt that done with autohotkey?how can I get the code for that?
Ahhhhhh. Now i understand. Auto-Hotkey is the program I use, but the code must be added to Auto-hotkey script like this:
#IfWinActive ahk_class wndclass_desked_gsk
:b0:with::{Enter}{Enter}{Enter}End With{Enter}{up 2}{end}
:*:then`n::Then{Enter}{Enter}End If{Enter}{up 2}`t
:b0:select case::{Enter}{Enter}{Enter}End Select{Enter}{up 2}{end}
:b0:do::{Enter}Loop{Enter}{up 2}{end}
::diml::Dim As Long{Left 9}
::dims::Dim As String{Left 11}
::dimr::Dim As Range{Left 10}
::dimd::Dim As Double{Left 11}
::lr=::LastRow = Range("A1").End(xlUp).Row
::Vbc:: & VbCrLf & "
::.r::.Range("").value{Left 8}
::ifn::If Not Intersect(Target, Range("H12")) Is Nothing
::apw::application.WorksheetFunction.Match("
These are just some, you can add your own as much as you want.
Thanks brother, God Bless You 😀
For sure, you are very welcome
thank you man it's a great work keep it up :) :)
For sure, you are very welcome I am glad you like it.
Fantastic! Thanks
Thanks so much Pietro, I am glad you liked it
Hi! Great video. Is it possible to make it with many sheet from different workbook.
Also I'm triying to seach and copying data from other workbook. Is it possible you help?
Hi thanks this is very possible and in fact my video being released tomorrow (6/12/2018) will show you how to connect data from another workbook, so I believe you will find it very helpful.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel
Hi sir, wanted to know how to hide columns which has multiple check boxes
Hi and thanks you can run an If/Then statement then use the Hidden = true option to hide the columns. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Please make one video on hospital management & pharmacy management in excel
HI and thanks so much. A hospital management application would be a massive software however I to have one on a Clinic Manager here: th-cam.com/video/9oebyN-ivhU/w-d-xo.html
I would consider a Pharmacy Manager in the future although i would have to understand more about the software.
Thank you for your Likes, Shares & Comments. It really helps.
Hi Andy, Thanks for this great video! I have created my own report followed your instructions in the video and it is working good except a small issue when i apply "TabGen" Macro, it really hide/unhide the targeted columns but the Screen automatically - by default - shows the columns start from "W,X,Y....->" column so i have to go with row to left (the page beginning) and this make hassle with me. How we can we solve that :)
HI Mohamed, thanks for your feedback. I am really glad you like the training. You can automatically scroll to any row or column in VBA with lines of code like this:
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Wow! it's fixed and working smoothly now :) regarding the group, i am already there. Good job and wish you all the best. Thank you!
Hey Randy.Thank you so much for this wonderful video.!Could you please lend me a hand. I got everything in my tab like this working perfectly. Just dont know how can I force the file to stay on the interface. Just like what happened with you at 22:13 that you need to scroll a little just to go to the interface again.I've tried application go to range scroll true but no success. Thanks in advance!🙂🙂🙂
HI Carmela, Thanks very much for your comment and question. I am glad you like the video. You can use ActiveWindow.ScrollColumn = 4 to get the application to automatically scroll to a specific column. 4 would be column D. I hope this helps.
Hi, Great video. Signed up to receive the spreadsheet in the tutorial but nothing has come through. Is this spreadsheet still available?
Hi, Yes it is. (I am changing email companies so this problem does not happen in the future) You can download this file from the following link: bit.ly/Horiz_Tabs
@@ExcelForFreelancers Thanks.
Hello sir, The all videos are best...
HI Vishal, thanks so much. I am really glad you like them.
A very well explained video. Thank you Randy.
Randy: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. Your help is greatly appreciated.
Yes, actually I have a course coming out in a month or two which shows exactly how to create drop down lists in Excel. Here is a quick 2 minute sample (no sound): bit.ly/DashSampleVid
Thank you for your reply. I am looking for more like a menu not drop down list.
Hi Randy, thanks for amazing tutorial. I've done it for 12 tabs (months), but I have a problem. When I'm changing the tabs one by one forward and backwards is ok but when I want to switch by 2 tabs backwards for example from March to January focus on the screen is outside the tables on empty space from cell FA to GA , last cell with the table is EZ. Could you please help on this one. I'm not sure what went wrong. Thank you.
Hi Kent, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Hi Randy, I don't have Facebook account please let me know if there is any other way?
Hi Kent, yes for sure. If you email me (Randy@ExcelForFreelancers.com ) I can refer a developer to help you with this. I hope this helps and thanks so much.
Brilliant tutorial as always. I have a doubt, say the tables are present in Sheet 1 and the display with tabs is present on sheet 2, what changes will have to be made to create this model?
Hi and thanks you will just have to update the code to specify a sheet # when saving and loading data. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
thanks for letting us see
For sure, you are welcome and happy to help
Amazing video. I have done this with 26 buttons. And all are working just fine. highly appreciated and thanks. I have just one query. Let me elaborate first. in this video, you have put the content into tabs from the same sheet, i mean the whole content was in a sheet. what if i want to put all my content into this tabwise format where these contents gotta be coming from different sheets? How do i write the code for that? I reckon this videos has been 5 years old, so if there is a chance that you might have already uploaded something that answers my query, would you please share the link? or help me anyway?
HI and thanks so much. I did create a video in which I had a tab system that actually hid columns to display contents all on the same sheet and the data was pulled from different sheets here: th-cam.com/video/5Bw7TZ0IJTo/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers i have another question if you dont mind. What if try this same procedure for verical tabs where i only have to place the shapes vertically instead of horizontally and keep the other things same as this video? Will that work?
Yes for sure it will work. I have several videos on that, just search my channel for 'Vertical' I hope this helps and thanks so much.
Thats great..................... I was looking for this work .....Thanks
Nusrat Ali Excellent happy to help
thanks alot
For sure, you are very welcome
Thank you very useful
For sure you are very welcome Mouhyiddine
Thanks great tutorial. I appreciate your efforts and generosity. really I was looking for type of tuite. please create opening user from as well
Hi Mohamad, Thanks very much. I am glad you like the videos. I do have a user form on opening here: th-cam.com/video/0ahYoy5L3ec/w-d-xo.html
Nice video advice
Thank you so very much, I really appreciate that.
thanks man, really awesome
Thanks so much. Happy to help and glad you liked it :)
Thanks A Lot Randy !!!!!
This Is Great 👍
This tutorial help us lot. I have created the same macros for 22 tabs, almost everything is fine though I am experiencing bit glitch while jumping from last tab to first tab. Display shows unknown range of cells ( Similar as in this video @ 22:12, when you click on first tab its slide away ). Is there any solution to get rid of this issue.
Many Thanks. :)
Hi thanks very much for your comment and liking the video. There could be a few reasons for this issue. Perhaps you can join our Excel For Freelancers Facebook Group here; bit.ly/groupexcel , then upload your screenshot and code so we can help you with the problem. Thanks so much.
Excel For Freelancers
Sure, will do. 👍
THANKS ALLOT ITS REALLY AWESOME
For sure, you are very welcome. happy to help
Thank you
For sure, you are very welcome