Userform submit VBA

[Frankinstyyn]

Hi Everyone,

I have created a user form and when a user clicks submit I have manipulated it so that the data in the command box goes to the correct column.

The problem i'm having is that it goes to the next blank space depending if there's data on the left or right. For example if there's data in cell A1 it would go to C2, I want it in C1 if it's blank

I would like it so that it will go to the next space in a specific column, regardless if there's data around it.

Here's the statement I have :

Please Login or Register  to view this content.

If anyone could help me I would really appreciate it!!

Thanks
Frank

[Norie]

Try this for determining the next blank cell in column C.

Please Login or Register  to view this content.

[Frankinstyyn]

Thanks Nori, I really appreciate your help.

Where do I put the code?

Would you like me to upload the spreadsheet to make it easier for you?

[Frankinstyyn]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.

Hi Fotis1991,

I've made the necessary changes, apologies and thanks for pointing it out.

[Norie]

The code I posted would replace this code, which was being used to find lrow in the original code.

Please Login or Register  to view this content.

[Frankinstyyn]

The code I posted would replace this code, which was being used to find lrow in the original code.

Please Login or Register  to view this content.

Hi Norie,

Thanks for helping, i'm not sure if it's the way I've got the spreadsheet laid out.

Now it doesn't go into the first space in column C and it overwrites anything in C4.

I've attached the spreadsheet with the original code and I would really appreciate it if you could have a look.

If E3 and F3 are empty, when the user form is submitted the data should go to E3 but it goes to E4

Thanks Norie I really appreciate your help!!!

[Norie]

What should I be looking at in the workbook?

PS Why do you have +0 in frmFinance2 here?

Please Login or Register  to view this content.

[Frankinstyyn]

What should I be looking at in the workbook?

PS Why do you have +0 in frmFinance2 here?

Please Login or Register  to view this content.

Hi,

You should be looking at view business improvement tab, column C.

The frmFinance was just what I named the userform

Thanks!!

[Frankinstyyn]

Hi,

You should be looking at view business improvement tab, column C.

The frmFinance was just what I named the userform

Thanks!!

Sorry, misread it.

I was trying to mess about with codes. I think it should have been minus or plus 1

[Norie]

It should be +1, as it is in the code I posted.

[Frankinstyyn]

It should be +1, as it is in the code I posted.

Okay, I've just changed it to +1 and now it seems to keep replacing everything in C4??

[Norie]

What is it that you want to happen exactly?

For example what happens if there's no data in rows 2:14?

Where would the data go then, where would it go next, where would it go after that and so on?

[Frankinstyyn]

With this particular code, I would like it that every time the user form was submitted the data would look for the next space in column C regardless of the data in A or B.

For example, if there was data from A3 TO A12 then I would like the data to go into C3 not C13

[Norie]

Sorry I don't quite follow.

How can you use column C to determine where data should go in other columns?

Do you want data to go in columns A and B until row 12 has been reached, then data goes into columns C & D until row 12 is reached and finally data goes into columns E and F?

[Frankinstyyn]

With this particular code, I would like it that every time the user form was submitted the data would look for the next space in column C regardless of the data in A or B.

For example, if there was data from A3 TO A12 then I would like the data to go into C3 not C13

[Frankinstyyn]

Apologies, I haven't explained things correctly.

I have 3 user forms for that page.

User form 1's data goes to column A
User form 2's data goes to column B
User form 3's data goes to column C

The one we are working on frmFinance2, all the data should populate column C

Hope that helps

[Norie]

Why 3 different userforms?

Why not one userform with option buttons, or a combobox, for the user to select whether it's a new action, closing an action or completed a review?

Whichever choice the user makes determines which column(s) the data should go in.

[Frankinstyyn]

Yeah, that was my next step i think.

I just didn't know if what I wanted was possible?

The idea was that someone was going to look at all of the data in one place.

So you would recommend the multiple choice userform??

[Norie]

Yes, it would make things a lot easier using just one form and one set of code.

It should be straightforward too, see the attached workbook.

[Frankinstyyn]

Yes, it would make things a lot easier using just one form and one set of code.

It should be straightforward too, see the attached workbook.

That's exactly what i'll do, thanks for your help!!!