Full Course: https://www.teachexcel.com/vba-course-update.php
(Downloadable files are in the full course.)
Free Couse Playlist: https://www.youtube.com/watch?v=QQNQObpAjL8&list=PLxhsXZXQXrUCKGlVG8xanGfvSX6h50a5Q
Part 3 of the UserForm Course.
How to make and use a Multi-column ComboBox in a UserForm in Excel.
UserForm Controls & Topics Covered Here:
- Add multiple values to a ComboBox at once.
- Add an array of values into a ComboBox.
- Create a multi-column ComboBox.
- Control which column is output in the ComboBox.
- The difference between the Text and Value property.
- How to set specific columns for the Text and Value property using the BoundColumn and TextColumn property.
- How to get values from any column in a multi-column ComboBox.
Full Version Includes:
- Multi-column ListBox examples - creating, adding values, getting values, and controlling the appearance.
- Getting multiple selections from a ListBox.
- Dependent ComboBox Drop-down menu lists.
- Removing items from a ComboBox and ListBox.
- Clearing a ListBox and ComboBox.
- How to use RowSource and Column headers programmatically.
Many more features, and topics are also included in the full course - this tutorial is just a sample!
Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_-UZLI-0evbA
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_-UZLI-0evbA
TeachExcel.com
#msexcel #howto #tutorial