This video looks at how you can add values from your spreadsheet into drop down lists in a user form and VBA within your application.
We like this video as it is clear and easy to understand and shows a really useful way to ensure that dropdown lists in a form are easily updated by a user without having any VBA experience or access to your code.
Finally we really like the way the video shows you how to add a simple dropdown list and a more complicated multi column dropdown by using the .list method to add items to a second column in the list box. This last item is really useful and you will probably find yourself using this more than the simple option.
If you find this video useful please share it using the links above or leave us a comment below.