Shared Workbook & User Form Controls

[egcausey]

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

 

[egcausey]

bump... anybody know?