Multiple Users in Userform issue

[bigbri]

Hi all,

I know I'm probably just forgetting something stupid, but here's m
issue:

I created a small userform to act as a Call Log. It worked fine, but w
had some Accumulation issues. So I set it up to have everyone's Userfor
to save to the same workbook on the Network drive. Everyone can pull u
the userform simultaneously with no issues, but only the first user ca
save data to the sheet.

I know the issue is probably a "Read-Only" problem, but I can't figur
out how to set it up where everyone's userform can write to the shee
at the same time (5 users). I had them pulling up the form from a loca
script, and tried also directly from the workbook on the network.

I'm good with VBA, but by no means great. Any help would b
appreciated.
-
Side Question: How hard would it be to save individual data on eac
person's local drive as well as to the main accumulative workbook?

 

[Simon Lloyd]

Hi as far as i'm aware it's like a sharing violation!, if 2 users have
the input box open and close it at the same time then both boxes will
be attempting to change the same cell, row or column..........excel
then wants to know who's changes wins? if they are changing seperate
cells or worksheets there shouldnt be too much of a problem!

I'm not too good at programming but if your workbook is on a network
drive could you write some code to check see if another input box has
been called if so then build in a timer before the check is performed
again and the all clear message being given...........sounds
simple........but i know it would be a nightmare!

Simon

 

[bigbri]

I originally thought of that as well. What happens in the form is when
the user clicks "submit," it writes all of the data to the next
available row, so unless two users click submit at the exact same
millisecond, it won't try to write to the same cells, and even if they
did, they can just click submit again and it should work. The problem
is that all subsequent users can't write to the sheet at all. I
originally didn't think there was an issue since everyone could open
the form at the same time.

 

[Guest]

I doubt this concept is supportable.

Perhaps put your data in an SQL database.

 

[Guest]

Just to be complete, you can go into tools=>share Workbook and make the
workbook a shared workbook which can be shared/used by multiple users at the
same time, but I am not sure you could have a userform in another workbook be
the one to share it. It might work, but sounds flaky to me.