Multi-select ListBox Displays Sheets Then Runs Code

**Shea2288** · 05-04-2016, 02:34 PM

Hello all,

I have a Multi-select ListBox in a UserForm that lists all of my Sheet names. I want to be able to select more than one sheet and then have a button run some code that will fill the first available cell with data that is in the textboxes. I need to have the program do this for every sheet selected. I have attached the project. This one has got me stumped...

Thank you.

**6StringJazzer** · 05-04-2016, 03:34 PM

I have renamed your textboxes to make it easier to know what they're for. See code updates in the UserForm module.

The idea is to find the next available row for data, then copy the four textboxes into the corresponding cells in that row.

You are going to have problems with data validation, though. Someone will type in "52" for a date or "May" for an amount. That is another thing for you to think about next.

**Shea2288** · 05-04-2016, 03:50 PM

Awesome. Thank you. My next step is to add a 'History' section in the userform to help avoid duplicate entries etc. I've attached the updated form with the history section.

I think I have an old program that checks for a proper date format so I might be able to use that code. Also, for amount I could make it numeric only. If you have any suggestions please feel free to suggest away.

This will help me out greatly. Thanks again.