I created a UserForm where the user inputs data for a record onto the
form. When they press a button, the record is loaded onto an excel
worksheet that exists on the same file as the form. The form inserts
one record at a time on the next empty row.

Is there a way for more than one user to simultaneously use a
centralized version of this form/workbook to populate new rows of data
into excel?

Each user would work from different locations. They'd access the
centralize workbook, type in their record, then press enter. Currently,
if two people are using the centralized form at the same time, only
select entries are saved. I want all entries to be saved, one beneath
the next on the worksheet.

Does anyone have a solution? I find it hard to believe that Excel would
have form capability without having a way for people to use the form
simulaneously. What, if anything, am I missing? Thanks all.

Michael