Multiple Users of VBA Userform, all data saved to one Sheet (Shared Workbook)

**Parth007** · 03-09-2017, 02:36 AM

Dear Experts.. need your advice & assistance

I've a workbook that is shared. This workbook has a userform to enter data into a single sheet. What it does is, when the user clicks on the userform button "UPDATE", it fills the first blank row available on the sheet.

Questions:

If there are multiple persons working at the same time on the file, if one fills the first blank row available (say row 2) and doesn't save right away, when another one is filling the first available row, it will be overwriten because this user also has the first available blank row as row 2, right?

Please suggest I am really stuck in this.. & I have to deliver it asap

I have to use shared workbook

Below is the code I am using.. Form Updated Button Code

Please Login or Register  to view this content.

**kasan** · 03-09-2017, 05:26 AM

Hi,
What if you calculate first empty row just after your userform is opened and after this row is found - write some text in column A, like "Waiting for new Record...", then save workbook immediately.
After user fills all values on your form (this perhaps take some time) - write them in already binded row.
In case some other user will open file to add his record - last row for him will be row below the row with "Waiting for new Record...".
Just make sure you delete row if no records was added, to make sure that your databese will not contain many rows with "Waiting for new Record...".