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