Forms in a Shared Workbook

[Lil_Lisa]

Hi there

I need someone's help and advice on running forms in shared workbooks.

It is a macro and based on one of the tutorials of this site. When the user completes the form and then by clicking OK it automatically fills in the first blank row. However if this workbook is shared and both users are on it at the same time and fill out the form at the same time the same blank row will be filled in. When one saves it and then the other saves it there is conflict resolution message. Is there anyway preventing this happening by adding something to the macro or creating a macro which gives the option for the user to place the information entered into the row below it?

I would be grateful for anyones help on this!!

Thanks

Lisa

[VBA Noob]

Shared workbooks are not the way in my view.

You need to be thinking of a access for this sort of thing

VBA Noob

[Lil_Lisa]

Thanks for replying. What do you mean by a access? Please could you point me in the right direction?

Thanks.
Lisa

[VBA Noob]

Microsoft access

Search google for database products

VBA Noob