Problem to tranfer userform's data in a specific sheet

[MariaPap]

Hi

I have this code

Please Login or Register  to view this content.

The red part of the code says :Φύλλο1. This is the translate of Sheet1 in our launquage!

In my sample example i have also a picture of the module to see it.

So Sheet2(Φύλλο2) is called "DataEntry" and

Sheet1(Φύλλο1) is called "DataBase"

The code works fine when i use sheet2-Φύλλο2, but not at all for sheet1-Φύλλο1!!

This getting me crazy.!

Any ideas pls?

[Solus Rankin]

Where is the code placed?

Try

Please Login or Register  to view this content.

[MariaPap]

Thank you for looking on this.

Code is for Command Button. Pls see my example sheet! I believe you'll find any info you need there.

Your suggestion.

Please Login or Register  to view this content.

Unfortunately, gives me an error.

Any ideas?

[Solus Rankin]

It gives you an error because that sheet doesn't exist. I don't have support for your language on my PC so I can't replicate exactly.

I believe you need to use the syntax Sheets("SheetName") where sheet name is spelled exactly how you have it in your workbook.

Or use index numbers, such as Sheets(1).

[MariaPap]

Thank you again. Playing with it i noticed that code works only in the specific sheet where the command button exist....

So,Let's say that this can not works.

Have you or of course anyone else how to do what i need?

New attachment without any code there is attached!

[Solus Rankin]

Move the code to the workbook module instead of a sheet module.

[MariaPap]

Move the code to the workbook module instead of a sheet module.

Now i am really comfused! Which code? The code of the command button? It's not in a sheet module...Did you open my attchment?

[Solus Rankin]

What is your ultimate goal with your code?

[ragulduy]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I'm not sure why the Φύλλο1 reference doesn't work, I get issues with the translation also so cannot reference the sheet by the vba name.

[MariaPap]

Eatch time that i type data in the userform, then these data to be tranfered in the first available row of DataBAse sheet. The name in column B. The address in column C. The phone in column D. The zip in column M AND the Email in column P.

The important is to transfer the data not in continues column but as i explained before(Bold part of my text)

Thank you.

[MariaPap]

Thank you yudlugar


Unfortunately this does't either works!!

[ragulduy]

In what way doesn't it work?

[Solus Rankin]

Still not exactly sure what you're trying to achieve. Perhaps:

Please Login or Register  to view this content.

[MariaPap]

Perhaps a small video could helps you for helping me.

http://screencast.com/t/bmEzEpdtQ7JR

[Solus Rankin]

I can't open the video due to the security policy at work. How did the code in #13 perform differently then expected?

[ragulduy]

Yeah I'm the same, can't watch videos.

[MariaPap]

Quys. I am geting crazy. For sure i am.

The last code of Solus works fine making 2 modifications!! Any idea why?

Please Login or Register  to view this content.

[ragulduy]

in what way doesn't it work without the modifications? Presumably your data in column B is different to that in column A, so you actually want the first empty row in column B to be erow, not the first empty row in column A?

[MariaPap]

so you actually want the first empty row in column B to be erow, not the first empty row in column A?

Exactly. If you see my sample in column A i have a formula to count the entrances! Of course i have to say that is the first time that i see the "erow" way and of course.. i am not able to understand haw this works.

I;ll study it and hope that i'll get it!

Many thanks to both of you!

[Solus Rankin]

Please Login or Register  to view this content.

Changing this to 1 shouldn't make a difference because you're setting the variable to the row number.