This week, I was asked how to load the sheet names onto a listbox and then when a sheet in that listbox is clicked – how to list the column headers in the second listbox! Sound crazy hard? No, it’s actually very easy. Check out the video below and Download the workbook here to try it out if you’d like!

You Might Also Like

Excel VBA UserForms #2

Excel VBA UserForms #2 Create a UserForm with 2 option buttons:  1 Sort by Employee ID or 2 Sort by Name. Part one, create the UserForm and give it buttons. First, bring up the VBA UserForm editor (F11), and add a new UserForm  using the...

Excel VBA Userform Basics #1

UserForm Basics #1 Here, you'll learn to make a UserForm, add a button, and make clicking on that button hide the UserForm! Make a UserForm: Press Alt-F11 to bring up Visual Basics menu Click the drop down menu in the upper left hand and select...

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.

Pin It on Pinterest

Share This

Share This

Share this post with your friends!