Assign ListBox items to active cell🔥Add items to ListBox🔥Unselect items🔥Table to listbox #excel #vba

preview_player
Показать описание
How to create multi-select dropdown list using List Box?
How to send the items from a List Box to a cell?
How to determine the previous active cell?

Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#excel #vba #dropdown #listbox
Рекомендации по теме
Комментарии
Автор

Sir you are amazing
But it would be great if you an indent like
If something then
For i = 1 to 5
Range("A" & i) = "Good"
Next i
End if

Also you can use single like If Statement like
If i = 0 then i = 1

Without end if

muhammadkausar
Автор

Hi, great video. I want to apply the list box to different sheets (2 or more worksheets), Can you teach me how to do that? Thanks

jamesl
welcome to shbcf.ru