Populating problems with User Form

Hi all,

I am running into some problems with my code for a User Form and I'm hoping to get some help.

Currently I have it set up so that you type data into one User Form and then based on that data this second User Form pops up (so far no problems with this).

Now when I fill out the data in the second User Form it's doing a couple of things.

1. Only the first two lines will populate to the specified worksheet.
2. When I run the Userform again it writes over the data (doesn't jump to the next blank cell)

Any insight you might be able to offer into this would be greatly appreciated. I have made a working User Form with all the data that I can revert to but I'd prefer to use multiple User Forms to keep the User experience simple, compartmentalized and clean.

Thanks!

Wolfman


CommandButton2 is the 'OK' button.

Please Login or Register  to view this content.

Originally Posted by Tinbendr

You will probably have to change the code for calculating the Rowcount2. Here's an article about prop and cons of different methods.

I took a look but am still having issues. Are you able to work through my code to give me an example?

This code gives me an invalid or unqualified reference error. What am I doing wrong here?

Originally Posted by Tinbendr

Please Login or Register  to view this content.

If this doesn't work, we'll have to see a sample.

What do you mean sample? Sample workbook?

I got this code to work but for some reason it puts a space between each entry. Any idea why?

Please Login or Register  to view this content.

ok this works:

Please Login or Register  to view this content.