Youtor
0902 Add a Combo Box DropDown List form control without VBA
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=i8wNriuqV8g
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.
#############################
