The Hidden Power Of The Excel VBA ListBox For VBA Beginners

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

КОМЕНТАРІ • 31

  • @ExcelForFreelancers
    @ExcelForFreelancers  23 години тому

    ⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

  • @JanBolhuis
    @JanBolhuis Місяць тому +1

    Thank you for this excellent video. Although I already use the listbox sometimes, your tutorial and explanation makes it a lot clearer and more efficient.

    • @ExcelForFreelancers
      @ExcelForFreelancers  Місяць тому

      That is so great to hear Jan. Thank you for your Likes, Shares & Comments. It really helps.

  • @R3ap4r
    @R3ap4r 2 місяці тому +2

    Nice one, i do it with an array, store my table, headers included and then fill the listbox and manipulate it.
    Kinda makes it a bit easier, less clutter on my sheet, feels faster as well. (Haven't run any speedtests yet)

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

      Thats a great idea and thanks so much for sharing. Arrays are fast and powerful. Thank you for your Likes, Shares & Comments. It really helps.

  • @raman-lj1vc
    @raman-lj1vc 2 місяці тому +1

    Wonderful video Randy, hugely helpful

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 2 місяці тому +1

    Thanks Randy for this amazing video.

  • @donniemcgee7523
    @donniemcgee7523 2 місяці тому

    Thank you for this tutorial. It is very helpful.

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 місяці тому +1

      For sure, you are very welcome and I am happy to help and share

  • @acounttemporary5017
    @acounttemporary5017 2 місяці тому +2

    Hi Randy! When will you create a Channel about Google Sheets where you will do ALL the COUNTERPARTS of what you did in Excel using VBA into Google Sheets using AppScript(JavaScript)?. I'm trying to do a transition now because most job listings requires knowledge in Automation in Google sheets. And I'm having a very hard time to convert what I did in VBA into JavaScript in AppScript Editor. 😢

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 місяці тому +1

      HI and thanks so much. I will be focused on Excel, until office scripts become more powerful. Google sheets scripts are simply not powerful enough to do what we do in Excel, that is why you are having such a hard time.
      I hope this helps and thanks so much.

  • @ranilan00
    @ranilan00 2 місяці тому +1

    Thank you Randy!
    Great Class.
    How do I make the second and third columns appear in the list box if I want to use the 'AddItem' method like you showed?

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

      Hi and thanks very much. For multiple columns its better to use the Named Range method with the RowSource and make sure to refresh that named whenever the data changes. That is the simplest method.
      Add Item method is great for single column list boxes and combo boxes. I hope this helps and thanks so much.

    • @ranilan00
      @ranilan00 2 місяці тому +1

      @ExcelForFreelancers I also prefer Named ranges, but curious about the add item!
      Thank you for your response!

  • @joemanflyer2001
    @joemanflyer2001 2 місяці тому

    Nice training video.

  • @sahralsahri7180
    @sahralsahri7180 2 місяці тому +1

    Thanks!

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 місяці тому +1

      For sure, you are very welcome and I am happy to help and share

  • @osamasaid8476
    @osamasaid8476 2 місяці тому +2

    thanks

  • @ReesBeest
    @ReesBeest 2 місяці тому +1

    I am ready

  • @ranilan00
    @ranilan00 3 місяці тому

    So Great!!

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 місяці тому +1

      Thanks so much. I am sure you are going to really enjoy this one. Thank you for your Likes, Shares & Comments. It really helps.

  • @HusamShaban-zr9cy
    @HusamShaban-zr9cy 11 днів тому +1

    dear sir ..
    I bought the package below but I do not know how to use it, where to start or what should be setup first, the only thing I did is downloaded the files. So please I do need your help with that .. I'll be waiting for your response .. many thanks in advance
    The Package:
    350 Excel Workbooks With PDF VBA Codebooks
    AutoHotkey with VBA Accelerator
    Ultimate Developer's Media Kit
    Excel AI Toolpack Add-In (Lifetime)
    The Ultimate Developers VBA Library (Lifetime)
    The Ultimate Excel Resource Guide
    Excel Calendar Pro

    • @ExcelForFreelancers
      @ExcelForFreelancers  11 днів тому

      Hi and thanks so much. The best place to start is within the downloaded file "350 Workbook Library.xlsm"
      This is a complete library of all the downloaded templates. This list also contains links to the UA-cam video for each template and a link to the workbook you have downloaded. You can find one you are interested in and then watch the video and work with the downloaded template
      For the Ultimate Developers Media kit, you can unzip it and use any of the pictures or content to develop your own applications
      You can find more details for the Excel AI Toolpack here: bit.ly/AIToolpack_RandyShared and instructions here: www.excelforfreelancers.com/docs/ai-toolpack-installation-overview/
      For the Ultimate Developers VBA Library you can find more details here www.excelforfreelancers.com/docs/the-ultimate-developers-vba-library-tutorial/
      For the Excel Calendar pro you can find information here: www.excelforfreelancers.com/docs/how-to-activate-your-license-key-for-excel-calendar-pro/
      I hope this helps and thanks so much.

  • @mjakabir
    @mjakabir 2 місяці тому +1

    😊

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

      Thank you so very much, I really appreciate that and so glad you enjoyed the training