Excel UserForm Course 2 - Menus, Lists, ComboBox, OptionButtons, CheckBox & More

Рет қаралды 39,289

2 жыл бұрын

Full Course: www.teachexcel.com/vba-course...
(Downloadable files are in the full course.)
Free Couse Playlist: • Excel UserForm Course ...
Part 2 of the UserForm Course - this tutorial covers many popular userform controls and shows you how to create them, put values into them, and store their values and selections in the worksheet.
UserForm Controls & Topics Covered Here:
- ComboBox in UserForms in Excel.
- ListBox in UserForms in Excel.
- OptionButton in UserForms in Excel.
- CheckBox in UserForms in Excel.
- CommandButton in UserForms in Excel.
Full Version Includes:
- Input validation.
- ComboBox validation.
- Input error message output.
- Robust coding practices that are easier to manage and control.
- Easy looping through OptionButton controls to figure out which option was selected and store its value in Excel.
- Looping through specific groups of option buttons to get their selection values.
Many more features, and topics are also included in the full course - this tutorial is just a sample!
Excel Courses:
- VBA/Macro Course: www.teachexcel.com/vba-course...
- Building Professional Forms: www.teachexcel.com/premium-co...
- Email Course: www.teachexcel.com/premium-co...
TeachExcel.com
#msexcel #howto #tutorial

Пікірлер: 18

@wayneedmondson1065 2 жыл бұрын

Nice tutorial! Thanks!!

@TeachExcel 2 жыл бұрын

Thanks Wayne! :)

@lisacapamagian4429 3 ай бұрын

This was brilliant thank you!

@tha2irtalib343 2 жыл бұрын

Thanks for sharing this article , it's helpful.

@TeachExcel 2 жыл бұрын

You're very welcome! I'm glad you think so :))

@TeachExcel 2 жыл бұрын

UserForm Free Couse Playlist: kzfaq.info/get/bejne/h7d-hLKT1afOfGw.html

@lyl8116 Жыл бұрын

When I do the listbox, what if the RowSource has duplicate value? How to code to make sure the listbox only contain unique value? Thank you!

@user-if8dj9kw2u 8 ай бұрын

very helpful material, but for some reason when I save new data or save an edit from the user form level, it takes about a minute, when I save it directly from the VBA code, it takes a second. Could you please help me?