EXCEL - COLLECTIONS CODE. Contribute to VanManKeyShare/EXCEL-COLLECTIONS-CODE development by creating an account on GitHub.

Code and procedures optimization / simplification. Here are a couple of tips to have in mind when you design a solution that includes loading Excel data into a Listbox in a UserForm: ...

When creating a Listbox in excel using the validation option, does anyone know how to change the format of the text in the listbox. Ex. default is set to black text. Does anyone know how to change ...

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.