anamika sharma
New Member
Respected Sir/Madam
Please give me a better solution...for vba prob.
I create a userform in excel vba for data entry..and i want to use this by multiple users at same time..but when i convert excel workbook in sharing mode. then macro is not viewed or edited..please give me solution how it is possible for one userform used by multiple users and my database last serial no is e.g. 10 then automatic next serial no is call by userform e.g.11 but it is possible when two or multiple users used one userform then autocall same last no..suppose one users open userform with serial no.. is 11 then 2 users open userform at same time with serial no. is 11 and then 1 user submit his data then database last serial no will be 11 then auto change 2 user serial no..or any massage show for change serial no... Dear Sir & frnd Please help me if you can....thankx in advance..
Please give me a better solution...for vba prob.
I create a userform in excel vba for data entry..and i want to use this by multiple users at same time..but when i convert excel workbook in sharing mode. then macro is not viewed or edited..please give me solution how it is possible for one userform used by multiple users and my database last serial no is e.g. 10 then automatic next serial no is call by userform e.g.11 but it is possible when two or multiple users used one userform then autocall same last no..suppose one users open userform with serial no.. is 11 then 2 users open userform at same time with serial no. is 11 and then 1 user submit his data then database last serial no will be 11 then auto change 2 user serial no..or any massage show for change serial no... Dear Sir & frnd Please help me if you can....thankx in advance..
