How To Create a Slide Out Menu In Microsoft Excel

Поділитися
Вставка
  • Опубліковано 7 вер 2024

КОМЕНТАРІ • 131

  • @ExcelForFreelancers
    @ExcelForFreelancers  4 місяці тому

    🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

  • @ganeshs1360
    @ganeshs1360 4 роки тому +2

    You take Excel to a whole new level each time. Excellent as always.

  • @kendethar
    @kendethar 3 роки тому +1

    This is why MS gives you rewards, Mr. Randy ... you deserve them

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      Thank you so very much, I really appreciate that Kendethar. :)

  • @rabiuahmad2689
    @rabiuahmad2689 11 місяців тому +1

    Great job🎉❤
    Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤

    • @ExcelForFreelancers
      @ExcelForFreelancers  11 місяців тому

      HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

  • @sasavienne
    @sasavienne 4 роки тому +1

    Your tutorials are unprecedented.

  •  6 років тому +2

    A very clever application to make a professional page, congratulations.

  • @TsiriniainaRakotonirina
    @TsiriniainaRakotonirina 4 роки тому +2

    Hey Randy, you never stop amazing me! For real, you have creativity and are really good at what you are doing.
    Keep it up!

  • @AshishUttekar
    @AshishUttekar 6 років тому +1

    Coz I loved the way you make the videos and you explain it

  • @CoderzF1
    @CoderzF1 2 роки тому +2

    you know you can add a DoEvents to each of those slide macros to have it actually appear animated. put inside those For loops. either at the beginning of the for loop or the end of the for loop will work

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      Thank you for your Likes, Shares & Comments. It really helps CoderzF1

  • @mdsaiful6294
    @mdsaiful6294 2 роки тому +1

    Good video

  • @junjor
    @junjor 2 роки тому +2

    amazing! and it works very well for me.
    but is there a way to prevent the menu buttons from disappearing when i have to scroll down the sheet?
    can you fix the menu in place?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      Hi and thanks Micha, while there is no way to fix a shape you can have a shape appear again as your scroll down.
      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

  • @nammarcr33737
    @nammarcr33737 5 років тому +1

    Wow Randy it's amazing and brilliant I too excited

  • @seekknowledge2714
    @seekknowledge2714 6 років тому +3

    wow you are amazing bro :), love your videos.
    Your sheets always look amazing and professional. How do you theme/color your sheets so beautifully like that ??
    Btw, ever thought of extending solutions to *Access* ? i am positive you can do exceptionally hilarious stuff with the power of Access

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      Hi thanks so much. I am really glad you like them. I will be having some comprehensive courses coming out soon.
      Access I used to do, and might get back into it sometime in the future. Much appreciated.

    • @jackeroo75
      @jackeroo75 4 роки тому

      Excel For Freelancers Unfortunately, Access isn’t used much in the corporate world and most are just using excel and power bi.

  • @egvNY
    @egvNY 5 років тому +1

    Awesome Mr Randy. !!!

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 років тому +1

    Brilliant. Thanks for this helpful video

  • @ritarita-yf9pc
    @ritarita-yf9pc 2 роки тому +1

    Nice

  • @muhamadfadli2898
    @muhamadfadli2898 4 роки тому +1

    Good job Randy I Like you

  • @ashwinkmr5735
    @ashwinkmr5735 4 роки тому +1

    Greetings Randy,
    Great video as always, thanks for sharing it!
    I was able to replicate everything except when I activate the slide in macro, the shape returns back to its original size, but it remained at the position it extended to when the slide out macro was enabled.
    --- Original Size and position
    ------------ After Slide out macro
    --- After Slide In macro
    I hope you have a solution for this.
    Thanks in advance!

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      HI and thanks very much. You can play with the properties "Size but don't move with cells" or "Don't Move or Size with cells" based on the location of your menu, one of these options should solve your issue. If not you can also set the Left positional based on a certain column within VBA,
      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

  • @malobosse229
    @malobosse229 4 роки тому +2

    Hi Randy,
    thanks for the great tutorial! I am trying to implement your solution to my project, but sadly I have some trouble with the ActiveX Labels: They always get in the way when I try to activate a macro attached to the graphical elements: The label will become visible and white on click. Any idea what I am doing wrong?
    Keep up the great work!

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi Malo, this may happen for a split second however you can turn off screen updating temporarily to minimize this effect. 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

  • @rofiqulislam7544
    @rofiqulislam7544 2 роки тому +1

    Good video ❤️❤️❤️

  • @AshishUttekar
    @AshishUttekar 6 років тому +2

    awesome buddy

  • @doreenmurphy2384
    @doreenmurphy2384 4 роки тому +1

    Hey Randy...Love your work..you make it all look so easy..question..I'm running Office 365 for mac and don't have the insert menu on my developer tab..will this only for Windows? Is there a work around for mac?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi Doreen, thanks for your comment. I have not spent enough time on a Mac for Excel to offer you much help at this point (I will be taking time to get better at Mac's very soon), however Ron DeBruin has some great Mac tips here. I hope this helps: www.rondebruin.nl/mac.htm
      Otherwise we also have an amazing group of experts in which I am sure you can get answers here: Excel For Freelancers Facebook Group here: bit.ly/groupexcel

    • @bevintx5440
      @bevintx5440 4 роки тому

      This info might help, though it's not for Office 365:
      answers.microsoft.com/en-us/msoffice/forum/all/missing-design-mode-in-my-develop-tab-ms-office/6fc68fad-e6dc-45b2-9d89-512b0d6ee059

  • @ME-vs7cl
    @ME-vs7cl 5 років тому +1

    WOW thanks bro

  • @mikekitt1649
    @mikekitt1649 3 роки тому +1

    This video is so amazing, thank you. But tried to follow hyperlink event on this on a hidden sheet but cant do it.. Kindly please aid/advise, appreciated in advance..

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +2

      Hi Mike thanks so much. This technique does not use hyperlinks however you want to use the Activate command within a macro to display the sheets. 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

  • @azharhusin6540
    @azharhusin6540 6 років тому +1

    Great job...

  • @bharathbabu5638
    @bharathbabu5638 6 років тому +2

    Amazing One Bro...

  • @AshishUttekar
    @AshishUttekar 6 років тому +1

    You should start one more playlist for basic VB tutorials...

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому +1

      I can of course, and would like to, but there are some really good ones, such as VBA Is Fun. I was trying to create something different. What do you think?

  • @twoheadlines
    @twoheadlines 4 роки тому +2

    Hi Randy. I am doing some coding using Excel 2019. I have run into a particular compiling error. The example is "Filename = ThisWorkbook.path & "\Database.xlsm"
    , with the compile problem relating to the semi-colon, in this case at the end of "&". Are you able to identify a solution please? I have experienced the very same problem with the similar coding that includes a semi-colon in one of your other applications. Otherwise I am learning something new from your Excel applications everyday. Thanks heaps

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi Stephan, If you are on a PC (not a Mac) the path should be Filename = ThisWorkbook.path & "\Database.xlsm"
      If you are on a Mac then the file path is different and you can learn more about that here: www.rondebruin.nl/mac/section3.htm
      Thanks so much for your comment.

    • @twoheadlines
      @twoheadlines 4 роки тому +2

      Thank you for the information. I use a PC. While I did not associate the particular coding with Excel on a Mac, I was eventually able to work out "amp" probably related to "ampersand" - hence "&". By removing the word "amp", I was quickly able to eliminate the compiling error. Thank you again. Onto the next challenge!

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Glad you got it to work. Yes "amp" should not be there which is why i also removed it in my code to you above.

  • @islamandtheworld8928
    @islamandtheworld8928 5 років тому +1

    Really amazing vedio Sir... very useful... Sir I have a question.. if we will create shapes instead of commond buttons in excel worksheet.. how the shape will change its back color on mouse move.. please help.. and send a code.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 років тому

      Hi thanks very much for your comment. The buttons I use are also shapes so you would just have to change the shape fill property. You can run a macro to see how this is done, then modify your code accordingly. 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

    • @islamandtheworld8928
      @islamandtheworld8928 5 років тому +1

      @@ExcelForFreelancers Hi, Thanks again... Sir, it would be your great favour if you give me some idea for a such fill properties.. or give a hint to write a code... thanks in advance..

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 років тому

      Hi thanks i am unable to here, but if you post your question in our facebook group we have 14,000 Experts who can help you.

  • @AbbassiTarek
    @AbbassiTarek 6 років тому +1

    Thanks so much

  • @tohirikagawa2919
    @tohirikagawa2919 2 роки тому +1

    Amazing excell, just not for data

  • @ogtactical2210
    @ogtactical2210 Рік тому +1

    Do you know of a way to prevent the label color from changing when it is clicked?

    • @ogtactical2210
      @ogtactical2210 Рік тому +1

      Actually just thought of a good fix. You can have the add the following to the hover label _mousemove and _click:
      Me. HoverLabel.Visible = false
      Me.MinAll.Visible = true
      And for the minAll you can add the opposite

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      HI and yes you can just keep the initial font color of the shape. Thank you for your Likes, Shares & Comments. It really helps.

  • @excelavon
    @excelavon 6 років тому +1

    Wonderful

  • @amantin
    @amantin 6 років тому +2

    12:48 - VBA for moving icon

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      Hi, thanks for your comment at the 12:48 Mark, that macro describes how to move the icon. you can download the free workbook with the links above to try it yourself.

  • @akbarmahfuzalam
    @akbarmahfuzalam 6 років тому +1

    Fantastic ...

  • @Honor2Ashes
    @Honor2Ashes 6 років тому +1

    Would you share the website with all of the icons you mentioned in your video?

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому +3

      Hi sure, this is one of my favorites: icons8.com/iconizer/

  • @didieknurdiansyah3739
    @didieknurdiansyah3739 6 років тому +1

    very useful video, but the link provided in the description just input email address. nothing came in my email. Please help.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому +1

      Hi thanks for your message. Perhaps it went to spam. Please reach me on facebook here so I can send you your download: m.me/ExcelForFreelancers?ref=Welcome%20message

  • @mohamadsiddeek7912
    @mohamadsiddeek7912 5 років тому

    I am sorry... Really I forget to appreciate your efforts. anyway so thanks. I love this tutorial send me more
    Thanks again

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 років тому

      Thank you so much Mohamad, I am so glad you like this tutorial. I have now 70 on my channel and I hope you can view and enjoy many of them. We are now creating an amazing Employee Manager, so please check out our current videos. Thanks again.

  • @levantateyora9317
    @levantateyora9317 4 роки тому +1

    what video you have that explain this from the beginning?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      HI this is the only video I have on slide out menu's. Some videos in the past I did not start from the beginning but all of my newer videos I generally start from scratch. Thanks for your comment.

  • @RubenGonzalez-pn9ou
    @RubenGonzalez-pn9ou 5 років тому +1

    Would it still work if you group the icon and the button?

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 років тому

      It should however you may have to ungroup to change the individual size of the buttons. Certainly worth a try

  • @MrKenzin
    @MrKenzin 4 роки тому +1

    when I Move Down mouse in lable navigation then lable not transparent,. it back color. can you fix it?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      HI this is not something that can be changed as it is part of Excel. Thanks very much for your comment. Cam on ban.

  • @SheridanWhiteside
    @SheridanWhiteside 5 років тому +1

    Hello, It seems like I got just about everything to slide in and out, but for some strange reason I have to hover the mouse about two cells up/down from the Icon to get the desired affect. Anyone have any suggestions? Thank you,

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 років тому

      Hi Eugene, thanks for your comment. The hover should work regardless of the cell its over. You will want to make sure the shape control is big enough so that the mouse hover is over the top of it and also make sure the shape control that hides it, is out of the way a bit. 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

  • @igorvieira8987
    @igorvieira8987 3 роки тому +1

    Its just for me that some icons change size? I changed the size of the rectangles ...

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      Hi Igor, thanks for your comment. Make sure in the shape properties options you set them to "Move but don't size" this way they won't change their size. I hope this helps and thanks so much.

  • @om_tandrala
    @om_tandrala 6 років тому +1

    Can't download the workbook using the link provided in the description..it is showing 403 forbidden error..pls provide a valid link

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      Hi Thanks we were upgrading out servers, but should be working great now.

  • @breakingbad582
    @breakingbad582 3 роки тому +1

    Master hi, when i click your slide menu open your the website.I wanna page link( sheet 1, sheet2 etc...)your slide menu. I tried but i couldn't. Could you please help me.Thanks in advance

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      Hi and thanks if you want to use a macro you can use a single line of code like this
      Sheet1.Actviate
      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

    • @breakingbad582
      @breakingbad582 3 роки тому +1

      @@ExcelForFreelancers Thanks yo so much master. I done👏👏👏😊

  • @Pteromandias
    @Pteromandias 6 років тому +1

    What is the link to the icon website?

  • @serrajav
    @serrajav 4 роки тому +1

    I downloaded the file it looks awesome by the way, however, when I move the cursor from one icon to another, it does not pop out right away or it pops out when I move to the next. The only way I found to get it to work properly is by reducing the "MinAll" square, but then I have to move the cursor out of the square and then back in, in order for it to minimize the popped out button, is there any way to fix this in the code?? Am I the only one experiencing this?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi Javier thanks for your comment. The solution would be to make sure there is enough spacing between the button so the user has time to hover over and open/close the menu. You can also write code to close the menus on selection change of any cell in the sheet. I hope this helps and thanks.

    • @gorflunk
      @gorflunk 2 роки тому

      2 things: 1) Your "hover" shapes are too large and are overlapping each other causing the code to operate erratically. Go into Designer Mode, open the Selection Pane and select one of the Hover shapes, resize it so it is the exact same width as the button it is associated with when the button is extracted (largest size) but only as tall as the button. 2) In the Selection Pane move that Hover shape in the list so it is below the button and icon it is associated with. Do these 2 things with the remaining Hover shapes. I placed all of my hover shapes at the bottom of the list in my Selection Pane. Make sure the MinAll shape is all the way at the very bottom of the list in the Selection Pane. Turn off Designer Mode. Enjoy!

  • @AshishUttekar
    @AshishUttekar 6 років тому +1

    can you share this file please

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому +1

      For sure, the link for download is about in the description, but i will also add it here: Download the FREE Workbook and follow along here: bit.ly/SlideOutMenu_DL

  • @KC_47.
    @KC_47. 4 роки тому +1

    My excel, don't have mouseMove option.. Why it happen sir??

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      Hi and thanks make sure you are using Excel on a PC so you get the full functionality. 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

    • @KC_47.
      @KC_47. 4 роки тому +1

      @@ExcelForFreelancers Hye sir.. I already requested for that group.. Please accept me.. I mean PLEASEEEEEE 😂 🤣 😂 🤣.. Btw, the answer is not solve my problem sir.. Bcoz I'm already using Excel in my office PC.. 😂

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi and thanks if you have not yet received admittance into the group please email angeli@ExcelForFreelancers.com and supply your email and fb id link so that they can help you with that. Thanks very much.

  • @erendiz79
    @erendiz79 6 років тому +1

    the slides are not responsive with the latest office 365 Excel edition. so it's not usefull.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      The browser based Office 365 does not handle macros. You would want to use any Excel Application that allows for macros.
      Thanks for your comment.

    • @erendiz79
      @erendiz79 6 років тому +1

      it's not on the browser based excel, i use the standalone desktop version and allow the macro's.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      erendiz79 If macros are enabled I'm not sure what the issue could be. Unfortunately I don't have that version I could test on. Perhaps someone in our Excel for Freelancers Group could shed some light on it if you post the question. bit.ly/groupexcel

  • @chanchaldas6229
    @chanchaldas6229 4 роки тому +1

    I'm not understanding your vba

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi thanks for your comment. Some videos are more advanced then others. This one is a bit more advanced.

  • @wayneseymour1
    @wayneseymour1 6 років тому +2

    link is click bait just to capture your email thats so not kool after a nice video... been two days now and no workbook thats BS

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 років тому

      Hi for sure it is not click bait. Sometimes emails go to spam so that can happen. I also offer facebook messages in which you can download the workbook directly from your messenger on most newer videos. Please download the file directly from this link (no email required) here: bit.ly/SlideOutMenu_WkBk
      I can assure you that I do want to get this workbook in your hands. Thanks for your patience and please feel free to email me should you have any questions Randy@ExcelForFreelancers.com

    • @christopherschembri7793
      @christopherschembri7793 6 років тому +1

      No it is not click bait. I have just downloaded it and it works as shown in this video.

    • @mdzen22e
      @mdzen22e 5 років тому

      I didn't received it after few hours now :(

  • @rabiuahmad2689
    @rabiuahmad2689 11 місяців тому +1

    Great job🎉❤
    Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤

    • @ExcelForFreelancers
      @ExcelForFreelancers  11 місяців тому

      HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

  • @mdsafiqulislam7503
    @mdsafiqulislam7503 2 роки тому +1

    Nice