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

  • 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. :)

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


    liv03,


    Cross posting without providing a link to the other post is strictly against the Forum Rules and is clearly stated as such when creating a new tread.
    You cross-posted at the Excel Forum. In my signature, click the link on cross-posting to understand why this is unacceptable and not tolerated on any forum.
    Future threads with cross-posts will be either locked or deleted without notice.


    Take the time to read the rules you agree to abide by so that you do not incur infractions that impact your posting privilege. You can access them via the link in my signature.