To register data from userform

[Oeysbrei]

Hi,

I have a code as you can see in the attached file. I have tryed to modify this to work as I want, but I failed and need help.
When opening the worksheet, there is only one command button. This will open a userform where I want to save the data from row 18. next time in row 19.

I now you people in here are superb, so hopefully somebody will help me solv this.

Thanks in advance.


Best regards
Øystein

[grimes0332]

You have basically got it right when looking for Lastrow, but you cannot get the Offset + 2 otherwise you will end up with every second row blank. In this situation, the Offset must be +1

The simplest thing to do is change the offset in the code and then move the text in A16 down a row if you must start in row 18 or simply just let the edited code start in row 17.

If you really do want to start in 18 and keep the heading in Row 16 then a further calculation using LastRow

Please Login or Register  to view this content.

... but you must change Offset + 2 to Offset + 1 whatever you do.

[Oeysbrei]

Thanks for youre reply,

I need to have the space between row 16 and 18, so that has to stay where it is. I cant see anywhere in the code were it says offset + 2.
I appreciate your help, but I still cant figure this out.

Regards
Øystein

[grimes0332]

Sorry, talking through my hat there. Mixed up with something I was doing myself.

You mentioned you need the blank row between 16 & 18 so just add that 1 line of extra code after you find LastRow. All it does is check what row has been determined to be LastRow; if 17 (no data in the list) then it'll adjust that to 18. Next time around, it'll calculate LastRow as 19 and just continue from there.

Please Login or Register  to view this content.

[Arkadi]

How about:

Please Login or Register  to view this content.

[Oeysbrei]

Thanks for great help,

This solved it, but I have added some text under for calculation, so I have to continue to work with this code to make it perfect.
I will make a new post to solv this next challenge

Thanks again.


Regards
Øystein