Stopping the save button from clearing textboxes on UserForm.

[bandito04]

Hello,

I'm looking for assistance with my userform. I am utilizing a shared workbook as a department dashboard. The macros are working as intended with the exception of my save button.

Issue:
Save button does in fact save the workbook with:

Private Sub CommandButton5_Click()
ThisWorkbook.Save
MsgBox "Log Entry Saved"
End Sub

However, with the workbook being shared, should another user add an entry, when the save button is clicked the conflicting changes pop-up displays. My idea is to have the user "Accept all other changes" which will then update their instance and allow them to resave their changes. However, when "Accept all other changes" is clicked and the workbook updates (saves) all textboxes on the UserForm are cleared forcing my user to reenter all data which can be pretty lengthy.

Is there a method I can utilize to prevent the save command button from clearing all fields. I have a Clear commandbutton set up to replace that function.

Thank you.

 

[mikenelena]

Hi bandito04,

One possible solution would be to use the Worksheet_Change event to capture any changes made to the worksheet and then programmatically update the form with the new values without the user manually entering them. You could also use the BeforeSave event to detect changes to the worksheet and then programmatically update the form with the new values. Finally, you could use the Workbook_BeforeSave event to check if there are any conflicting changes and prompt the user to accept/reject them before saving the workbook. If they accept the changes, you can then programmatically update the form with the new values.

 

[bandito04]

Hi bandito04,

One possible solution would be to use the Worksheet_Change event to capture any changes made to the worksheet and then programmatically update the form with the new values without the user manually entering them. You could also use the BeforeSave event to detect changes to the worksheet and then programmatically update the form with the new values. Finally, you could use the Workbook_BeforeSave event to check if there are any conflicting changes and prompt the user to accept/reject them before saving the workbook. If they accept the changes, you can then programmatically update the form with the new values.

Thank you for this!

Ultimately found that i had written in the code to =" " for each value after i hit the save button. So i was my own meance.

I can definitely use these events you listed for other aspects of my workbook so i do appreciate your reply!!