Help with a vba code to overwrite cell data

**Zimmerman** · 03-06-2016, 11:04 AM

I have a sheet called "Player Info". And the data on this sheets gets entered in from a userform. The code below works great but what I would like to do is when the user clicks a button on the userform (commandButton3), I would like to update the info on the Player Info sheet with the new data entered in from the userform. Right now it just adds another row with the same data. For instance if I want to change the data in textbox3 from AM to AL right now it just adds all the data again. Sorry I forgot to mention that This userform is brought up by double clicking a cell and auto fills in with the data already on the sheet. This code is below the first code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for the help in advance
Excel 2010

**AlphaFrog** · 03-06-2016, 11:23 AM

It looks like you are populating the UserForm with data from the ActiveCell row. This will write back to that same row.

Change this...

Please Login or Register  to view this content.

To this...

Please Login or Register  to view this content.

**Zimmerman** · 03-06-2016, 11:30 AM

Very simple but absolutely perfect. Exactly what I needed. Thank you so much!!!

**AlphaFrog** · 03-06-2016, 11:43 AM

You're welcome. Thanks for the feedback.

**gmr4evr1** · 03-06-2016, 11:45 AM

Dang, it was that simple!!?? I just went and rewrote the code that I use (that was provided by a member here) to edit a row with my userform to work with Zimmerman's userform and came back and it was already solved

Oh well, not sure if the code I have would have worked 100% though.
Here it is just in case.

Please Login or Register  to view this content.

You might have to change the numbers in the (Target.Row, x) to the number of the columns you need the info from.

Help with a vba code to overwrite cell data

LinkBack

Thread Tools

Rate This Thread

Display

Help with a vba code to overwrite cell data

Re: Help with a vba code to overwrite cell data

Re: Help with a vba code to overwrite cell data

Re: Help with a vba code to overwrite cell data

Re: Help with a vba code to overwrite cell data

Thread Information

Users Browsing this Thread

Similar Threads

Sync data on two sheets and instead of overwrite comment the changes in the cell

prevent data cell overwrite

Code for asking for overwrite YES/NO

Prevent data cell overwrite but allow blank cell overwrite

VBA code to overwrite contents of cell

Add cell data to blank, but do not overwrite data

if cell has data or values then cannot overwrite

Bookmarks

Bookmarks

Posting Permissions