Share via

Allow multiple users to access and fill in the userform in excel file simultaneously

Anonymous
2011-05-30T03:55:12+00:00

Hi, I have the problem for allowing multiple users to fill in the userform which I have created simultaneously. The problem is when one user is filling in the form, the other user appear to be 'Read Only' once they open the excel file. Are there any solutions to solve this problem?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-06-01T04:51:27+00:00

It depends on your setup of course.

You could write a bit of code in the commandbuttons click event, something like:

Private Sub CommandButton1_Click()

    With Worksheets("sheet1")

        .Select

        .UsedRange.AutoFilter 1, ComboBox1.Value

    End With

End Sub

The code filters sheet1 on column A using the content of combobox1.

Was this answer helpful?

0 comments

20 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-06-06T23:30:06+00:00

    So I have another question. Is it possible to use VB coding to link one workbook to another workbook? Let's say I have my worksheets to being filled up by the users in "Workbook A", once they have filled up and click on the "Submit" button, their record will automatically being recorded into another workbook named "Workbook B". Will it be possible? If it is possible, what is the way for doing this? If VB coding is needed, please give me some direction on how to code it. 

    Thank you so much.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2011-06-03T17:44:51+00:00

    Yes, Access is capable of handling multiple users.

    Of course if two users try to edit *the same* record at the same time, the second one opening that record will get a warning when he tries to commit the changes to the record.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-01-06T10:25:13+00:00

    Yes. You can use the Workbooks.Open(FileName) and Workbooks(FileName).Close tools

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2011-05-30T10:05:44+00:00

    If you have never used Access I guess this won't be an easy task.

    You could use a work-around, which would work more or less like this:

    • The form is in Excel file A
    • The data is in file B.

    Once the user clicks "save" on the form, VBA tries to open file B. If it opens read-only, then it waits a bit. After some time tries again to open FIle B. If file opens read-write then write the data and close and save file B.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments