Assign ListBox items to active cell🔥Add items to ListBox🔥Unselect items🔥Table to listbox

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?
Multi-select in-cell dropdown menu in Excel 👉 • How to create multi-se...
Excel & VBA discussion public group 👉 / 486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗
#excel #vba #dropdown #listbox

[@muhammadkausar2842]

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
❤

[@ahsing_excel_VBA]

Thanks! Thank you for your suggestions.
The reason I didn't indent is because it would increase the length of the code and might cause it to extend beyond my recording region. As you may have noticed, I use a larger font size and have enlarged the VBA script editor to enhance readability.
Most of the time, I assume my audience has their own customizations, so I use multiple lines for 'If' statements. This allows them to add conditions as needed.
Thanks for watching. Wishing you a wonderful day.

[@muhammadkausar2842]

@@ahsing_excel_VBA thank you sir

[@jamesl1233]

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

[@ahsing_excel_VBA]

Hi. Thanks!
If you are using the 'SelectionChange' event, copy the code and paste it into all necessary sheets in the VBA editor. Also, ensure that there is a list box on each spreadsheet.
Thanks for watching and have a nice day.

[@jamesl1233]

​@@ahsing_excel_VBA thanks for your reply. is there a way just only create one List objects, then apply to other sheets. Instead creating list objects on each sheets. Thanks

[@ahsing_excel_VBA]

Yes, there is. Instead of using controls, you may consider using a UserForm. Then call the UserForm whenever a cell within the desired ranges is selected.

[@muhammadkausar2842]

Also you can Create an Add In from that
Then it will be available All your workbook or worksheet
But you have to knowledge of the Class Modules