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.
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)
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. 😢
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.
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.
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
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.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
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.
That is so great to hear Jan. Thank you for your Likes, Shares & Comments. It really helps.
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)
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.
Wonderful video Randy, hugely helpful
Thank you so very much, I really appreciate that Raman :)
Thanks Randy for this amazing video.
For sure, you are very welcome Syed, much appreciated
Thank you for this tutorial. It is very helpful.
For sure, you are very welcome and I am happy to help and share
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. 😢
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.
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?
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.
@ExcelForFreelancers I also prefer Named ranges, but curious about the add item!
Thank you for your response!
Nice training video.
Thank you so very much, I really appreciate that
Thanks!
For sure, you are very welcome and I am happy to help and share
thanks
For sure, you are very welcome and thanks so much Osama
I am ready
Great, thanks so much. I Hope you enjoyed the training
So Great!!
Thanks so much. I am sure you are going to really enjoy this one. Thank you for your Likes, Shares & Comments. It really helps.
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
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.
😊
Thank you so very much, I really appreciate that and so glad you enjoyed the training