VBA user forms queries to have live clock to track real time

[NikhilDixit]

Dear Champions;


Based on User Form developments i have below questions;

1. I have created the user form and shared with more than 20 users to fill in.
All data goes to one master file. The code i need is for when the multiple users simultaneously submit data it ask to replace the data or says that "the file already exist do your to want to replace it"....

Question: What code i need to avoid such errors and it saves data coming from multiple users


2. In user form, I have inserted the below formula in text box to have current date and time but the time does not change when i submit my data unless i close the form and reopen it. File attached for your reference

I really want the live clock and taking real time submitted....

Unable to upload user form for the reference.

TextBox_Treatment_Date_And_Time.Value = Format(Now(), "dd-mmmm-yy h:mm:ss")

Capture.PNG

[Logit]

.
Here is a small project showing running time in a LABEL positioned on a UserForm. Hopefully you can use this to obtain your goal.

Please Login or Register  to view this content.

Regarding your question :

Question: What code i need to avoid such errors and it saves data coming from multiple users

The issue you are experiencing is common to EXCEL. You can do a 'workaround' by having each of the users entering data to their own file and your MASTER FILE
periodically reviewing the user files to obtain updates to the MASTER. That way each user is only accessing one file (theirs), they can do it anytime they want without
interference from another user.

[NikhilDixit]

Well Noted