How To Create a Slide Out Menu In Microsoft Excel

Поделиться
HTML-код
  • Опубликовано: 14 окт 2024

Комментарии • 131

  • @ExcelForFreelancers
    @ExcelForFreelancers  5 месяцев назад

    📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

  • @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. :)

  • @sasavienne
    @sasavienne 4 года назад +1

    Your tutorials are unprecedented.

  • @rabiuahmad2689
    @rabiuahmad2689 Год назад +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  Год назад

      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

  • @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!

  • @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

  •  6 лет назад +2

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

  • @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.

  • @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

  • @doreenmurphy2384
    @doreenmurphy2384 5 лет назад +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  5 лет назад

      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

  • @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.

  • @AshishUttekar
    @AshishUttekar 7 лет назад +1

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

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 лет назад +1

    Brilliant. Thanks for this helpful video

  • @nammarcr33737
    @nammarcr33737 5 лет назад +1

    Wow Randy it's amazing and brilliant I too excited

  • @egvNY
    @egvNY 5 лет назад +1

    Awesome Mr Randy. !!!

  • @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.

  • @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

  • @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

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад

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

  • @muhamadfadli2898
    @muhamadfadli2898 4 года назад +1

    Good job Randy I Like you

  • @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👏👏👏😊

  • @rofiqulislam7544
    @rofiqulislam7544 2 года назад +1

    Good video ❤️❤️❤️

  • @HeyTCT
    @HeyTCT 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

  • @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.

  • @ritarita-yf9pc
    @ritarita-yf9pc 2 года назад +1

    Nice

  • @tohirikagawa2919
    @tohirikagawa2919 2 года назад +1

    Amazing excell, just not for data

  • @Honor2Ashes
    @Honor2Ashes 6 лет назад +1

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

  • @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

  • @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

  • @bharathbabu5638
    @bharathbabu5638 7 лет назад +2

    Amazing One Bro...

  • @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.

  • @ME-vs7cl
    @ME-vs7cl 5 лет назад +1

    WOW thanks bro

  • @azharhusin6540
    @azharhusin6540 6 лет назад +1

    Great job...

  • @AshishUttekar
    @AshishUttekar 7 лет назад +1

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

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 лет назад +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?

  • @AshishUttekar
    @AshishUttekar 7 лет назад +2

    awesome buddy

  • @AbbassiTarek
    @AbbassiTarek 6 лет назад +1

    Thanks so much

  • @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.

  • @excelavon
    @excelavon 6 лет назад +1

    Wonderful

  • @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.

  • @akbarmahfuzalam
    @akbarmahfuzalam 6 лет назад +1

    Fantastic ...

  • @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

  • @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!

  • @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.

  • @mohamadsiddeek7912
    @mohamadsiddeek7912 6 лет назад

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

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 лет назад

      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.

  • @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.

  • @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.

  • @AshishUttekar
    @AshishUttekar 7 лет назад +1

    can you share this file please

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 лет назад +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

  • @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 Год назад +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  Год назад

      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