Hello!
I am attempting to create a shared workbook with 3 different "types" of users, with multiple users of each type. Every user will have his or her own tab in which to operate. However, I want to create a User Form object for each type where users will be able to input and update data. I forsee a conflict if two users of the same type are both trying to update data using the "same" User Form.
Therefore I have three questions:
1. Will multiple users trying to "show" and edit the same form (at the same time) cause conflicts in a shared workbook?
2. Can I get around this by creating a new reference for each user to the form and initializing as required?
For Example:
Dim frm_type1_user1 as Type1UserForm
Dim frm_type1_user2 as Type1UserForm
Dim frm_type1_user3 as Type1UserForm
...
set frm_type_user1 = new Type1UserForm
...
set frm_type_user2 = new Type1UserForm
...
set frm_type_user3 = new Type1UserForm
3. Is there something I'm missing? Best practice in this case?
Any help would be greatly appreciated!
Thanks,
Griffin
I am attempting to create a shared workbook with 3 different "types" of users, with multiple users of each type. Every user will have his or her own tab in which to operate. However, I want to create a User Form object for each type where users will be able to input and update data. I forsee a conflict if two users of the same type are both trying to update data using the "same" User Form.
Therefore I have three questions:
1. Will multiple users trying to "show" and edit the same form (at the same time) cause conflicts in a shared workbook?
2. Can I get around this by creating a new reference for each user to the form and initializing as required?
For Example:
Dim frm_type1_user1 as Type1UserForm
Dim frm_type1_user2 as Type1UserForm
Dim frm_type1_user3 as Type1UserForm
...
set frm_type_user1 = new Type1UserForm
...
set frm_type_user2 = new Type1UserForm
...
set frm_type_user3 = new Type1UserForm
3. Is there something I'm missing? Best practice in this case?
Any help would be greatly appreciated!
Thanks,
Griffin
Last edited:
