[Solved] Macro Help for cell replace vs. dropping down

[jbagnall2004]

Hello Everyone,

I am trying to create a UserForm and I am almost done.

The problem I am having I have this UserForm that sends information from a text box on to another sheet. When someone puts in that information it goes to the first empty row and puts that information in the 1st, 2nd, 3rd cell. As you start to add more and more information it will drop down to the next row.

How do I make it so that way if a person puts information in to a UserForm it will replace the information in the first row and not go down a row?

Let me know! Thanks in advanced.

Please Login or Register  to view this content.

[jolivanes]

If you take the +1 out at the end of the lRow line, does that do it?

BTW, could you put code tags around your code please.

[jbagnall2004]

Sorry about. New to VBA coding and this forum. I tried taking off the Row+1 and it didn't work. What else could I try?

Before :

Please Login or Register  to view this content.

After

Please Login or Register  to view this content.

[jolivanes]

NOT "Row + 1", just the "+ 1". Leave the Row where it is.
I don't know if that is the problem. Would need an attached file from you to try it on.

[jbagnall2004]

Like Magic! You are the best! Wish I could donate to you

[jolivanes]

All that matters is that it works. If you're happy, the whole world is happy for you.
Good luck