Dynamically Fill ListBox on Excel VBA UserForm

preview_player
Показать описание
This video demonstrates dynamically filling a ListBox control on an Excel VBA UserForm by selecting an item from another ListBox.
Рекомендации по теме
Комментарии
Автор

Gracias milessss!!! Excelenteee! Lo estuve buscando mucho tiempo.. (in my bad english.. it will be.. Thanks a lot, i was looking for it since a long time. I really need this.. THanks, again, Nancy from Argentina

Nanzyz
Автор

Thanks a lot for the tutorial! Can you share the workbook and the code?

yousingcountry
Автор

For me this code is not working. I checekd the range naming and everything is correct. I do not understand why it is not working

maksiowisniewski
Автор

This is exactly what I'm looking for... But I need more! How would I display all the selections on the user form itself? And then option for delete/removal? How could I display the current data in the user form, and then add more from the drop down selections?

svenlouis
Автор

Very helpful. How would you implement that technique in Word? Where would you store the data for the list boxes?

HoppiHopp
Автор

Very useful for me.Tks u very  much!Could you please do example same thing with Checkbox and CommandButton?I have many Checkbox and  1 CommandButton.I want to Excel can do following step below:
1. Select Checkbox (CheckBox.Value = True) then Value will be shown on Cell A1, B1, C1...2. Click CommandButton then all Checkbox will be reset (mean unselected: Checkbox.Value = False) And If I select CheckBox value will be shown at next row A2, B2, C2, .. but value at Cell A1, B1, C1...still be kept.Tks u!

vcn
Автор

as I do, to show the image side, so
to click it will show the image .
Att:
Elso

elsobrucelee