I have a userform in excel VBA that about 40 people use. When submitting data through the userform to write on the sheet it works perfectly. However, I tested with 5 users simultaneously using this same form and it seems like OneDrive syncing starts to mess up with the submitions (lines are being overwritten).
Is there a work around so that this overwritting does not happen when users are submiting data simultaneously?
You haven't provided much information about how you've set this up or how it's used but, as I'm picturing the shared workbook, you could determine and "reserve" the destination location upon opening of the userform, instead of upon completion.
There are a number of issues you'd have to work through, as co-authoring in this way can be tricky, and this is not ideal. Ideally you'd be transitioning to MS Access or another relational database. (If you already know some basic VBA, the learning curve isn't as steep as it might seem.)