Populating ListBox on UserForm from different columns of data from a worksheet

[Pi_Lover]

Good afternoon. I have tried and failed at several attempts to populate a ListBox that I have on a UserForm, from data on a worksheet. The issue I have ran into is that I am trying to populate data from several columns, while leaving some columns left off the ListBox. As an example: I want Col. B, C, AG, AK, AZ, etc to populate (15 columns in total), leaving out all the columns between those. I've also had problems getting the headings of the columns to match the same width of the columns of data with in the ListBox. Then, eventually, I will want to populate TextBoxes with in the Userform that will populate on another worksheet (This worksheet will end up being a report to be printed off). What I am looking to do is code it in a way to add specific columns under the headings from the worksheet. I can load an example worksheet into DropBox

 

[Pi_Lover]

Dropbox

www.dropbox.com

 

[NoSparks]

Your example workbook has no user form

 

[Pi_Lover]

Your example workbook has no user form

*Facepalm. Sorry about that. I uploaded the wrong spreadsheet. Try this one:

Dropbox

www.dropbox.com