Multiple Users of VBA Userform, all data saved to one database

**oliver_l** · 08-21-2010, 08:10 PM

Hello,

I'm pretty new at VBA and was wondering if you could help me out on this:

I have created a VBA userform but will need to have it used by at least 5 users. My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet? if yes, would you be kind enough to share the code?
MS Access is not an option for me so I was wondering if you could help me do this in excel.

thank you so much and would really appreciate to hear from anyone soon.

**shg** · 08-21-2010, 08:16 PM

I think Teylin said it best: There are two kinds of shared workbooks; those that are already corrupt, and those that will be soon.

I'd figure out a different approach, starting with revisiting why you can't use Access.

**oliver_l** · 08-21-2010, 08:22 PM

our office security has limited the applications installed in our PCs so i dont have access available.

I also thought of sharing the workbook and have all users launch the VBA from there (not sure if its going to work though) but I prefer that they do not see the values they've saved through the userform so they will not be able to edit them. So having a main database where all the saved data from the userform go is the best solution for me, i just got no idea how to do it.

**oliver_l** · 08-21-2010, 09:10 PM

Any thoughts?

**shg** · 08-22-2010, 01:06 AM

Cross-posted at http://www.ozgrid.com/forum/showthre...d=1#post518670

**MarvinP** · 08-22-2010, 01:09 AM

If you have 5 people simply adding to the data and saving records you could accumulate them later. Each would be using their own copy of Excel and the same looking userform. If you have 5 people all trying to update or edit the same data there will be a problem. You could copy the userform to each person's excel file, have them enter data all day and in the evening move all records to a master spreadsheet.

**royUK** · 08-22-2010, 01:41 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this