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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Populating ListBox on UserForm from different columns of data from a worksheet
- Thread starter Pi_Lover
- Start date
