Grids Course Part 6 - Pulling Excel Data To Grid
Вставка
- Опубліковано 6 вер 2024
- 📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
In this episode, we're showing how you can pull data from a hidden worksheet onto the ExGrid control so that you can now sort, filter, edit data and restrict as you need - and this grid control can appear on a Userform or Sheet, which gives you a lot of versatility in controlling your data.
Download Follow-Along version: www.excelvbais...
Download Completed version: www.excelvbais...
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...
How to get" list index name" on combobox vba excel
Example: Select Country
Hi achyut, not sure what you mean by list index name, but if you need the value of an item that is selected from a combobox, typically you can get this by referring to the .Value or .Text property. If you need the index number of the selected item, you should do ok with the .ListIndex property.
Is this 32 bit version?
Hey jerome! This works on 32 bit and 64 bit versions of Excel. You just have to get the correct version of ExGrid to match your version of Excel. This link has both versions of the demo -> www.excelvbaisfun.com/gridhelp