Miscellaneous lessons from the Expert Skills course. - 09-02: Add a Combo Box (Drop-Down List) form control without VBA

4.0 (1)

15 learners

What you'll learn

This course includes

2.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

combo box drop-down list combo box excel combobox excel excel combo box dropdown userform combobox excel combo box tutorial combo box without vba drop down list in excel excel combo box list create and use a combo box

Full Transcript

In this lesson, without the need for any VBA code, you will master the correct use of Excel's Combo Box form control. You'll insert a perfectly sized Combo Box form control into a professional-grade, real-world business form. You'll then define source data and use it to populate the control. As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson. ⌚ Timestamps 0:00 Sample file download instructions, download link, and discussion of sample workbook. 0:10 Insert a combo box into the worksheet. 1:08 Create a range of formatted values to populate the combo box. 2:26 Convert the range to a Range Name to use with the combo box (best practice). 3:00 Set the range as the source for the Combo Box control. 3:24 Test the Combo Box. 04:11 Link to next lesson, course session playlist and to download sample file set.