Excel Userform: Update cell with new data without overwriting existing data

[egrospe17]

Hi there,

I have a userform that contains a text box for comments and is routed to a specific cell in an excel sheet. There is another comments box on another userform that will prompt the user to add comments as well and that data needs to go to the same cell in the excel sheet.

Is there a way that the userform can update the cell without over writing the existing data with a click of a command button? Also I would prefer if there is a blank line in between the existing and the new data.

Thank you in advance for your help!

[jaslake]

Hi egrospe17

Something like this perhaps...

Please Login or Register  to view this content.

[egrospe17]

Hi egrospe17

Something like this perhaps...

Please Login or Register  to view this content.

Perfect! That worked great!! thank you!

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[egrospe17]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Done for you jaslake - One more follow up question though... If I have multiple sheets in my workbook, how do I reference that in the code you provided? I just want to make sure it goes to the correct sheet. Thanks again!

[jaslake]

Hi egrospe17

Change the Sheet Name as appropriate...

Please Login or Register  to view this content.

[egrospe17]

Thank you! Cheers!

[jaslake]

You're welcome...thanks for the Rep.