Basic Userform to populate sheet not working

Thank you for pointing out the new rule, my apologies. It's fixed now.

Hi Betsy!

If I'm understanding your goal correctly, you simply want the selected value in the "Team" combobox to be entered into the first empty line below the "Team" column header on sheet 2 when the "Update" button is clicked, correct?


If that's all you're after, there's a much simpler way to achieve it than the code you are currently using. Try this method instead:

Please Login or Register  to view this content.

In my example, I've added lines to print the column header value in each of the other columns as a text string, but you would simply replace the portions in quotes with the following:

Please Login or Register  to view this content.

Where "XXXX" is the name of each additional combobox you set up for the other columns.

I've attached a revised version of your example workbook with my code above inserted on the "AddRecordButton_Click()" event, so you can see how it works by clicking "Add Record" instead of "Update". You should be able to tweak the code from there to fit your needs.

If you were going to use my method to replace the relevant section of code you currently have on the Update button, it would look something like this:

Please Login or Register  to view this content.

The lines I noted as "not needed" should be deleted, unless your full project has another purpose for those functions. I also recommend getting in the habit of indenting each section of code like I have done, particularly your "if" statements, to make your code easier for others to read and work on.

Let me know how that works for you! Happy coding!!!

Here, since I had it done anyway, I've attached my final version of your example file, with my code replacing your original code instead of being on the Add Record button... Hope this helps!

Originally Posted by Betsy Simpkins

Thank you for pointing out the new rule, my apologies. It's fixed now.

Thanks for your attention. It's not a new rule; it's always been a rule.

YES! Thank you Arnold this is exactly what I needed. Appreciate the help!

Thanks Bakerman2, this is super helpful as well!

Originally Posted by Betsy Simpkins

YES! Thank you Arnold this is exactly what I needed. Appreciate the help!

No problem, glad I could be on the giving end of the help instead of the receiving end like usual, LOL!

Don't forget to mark the thread as "Solved" if you're good to go... and maybe throw a click on the "add reputation" button if you feel so inclined.