User Form Controls - Connect ComboBox Selection to Listbox

Looking for vba Code that allows the user to select an item from a comboBox that populates a listbox with three columns.

Please Login or Register  to view this content.

Andy,

I understand I should have clarified that based on the "Year" selected I would like the list box to display columns "C", "E", and "O".

thanks

Andy,

I notice when I select a year from the drop down, in the list box the header is below the item did I miss something else?

This how is looks

ENC Test.png

I notice the add items fill the first column. I'm work on that this afternoon

thanks

Andy I modified the code which looks correct need a little help connecting the drop down box to the list box. I added an additional worksheet called reports

Please Login or Register  to view this content.