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!

[adrotate group=”3″]

You Might Also Like

Create Sheets For Each User From Column A

Create Sheets For Each User From Column A

Sometimes in Excel, we need to automate simple tasks, like to create sheets automatically for each item in a range. If you just had a few worksheet tabs that needed to be created, it wouldn't be a big deal, but what if you had to create 100 different worksheet tabs?!...

How To Add A Date Picker Calendar in Excel VBA

How To Add A Date Picker Calendar in Excel VBA

Date Picker Calendar in Excel VBA Oftentimes, users want to click a button and select a date. This is no different for Excel developers. Check out this ActiveX control by Microsoft that allows users to do just that. It's a little old school looking, but actually has...

X

Forgot Password?

Join Us