+ Reply to Thread
Results 1 to 4 of 4

How user Form can be accessed by multi user in online?

  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    How user Form can be accessed by multi user in online?

    Dear Forum,

    I need your support and guidance on the following:

    I have developed 3 data entry tools using user form in excel 2013. All three user forms are in single workbook. These three user forms have been linked with other user form as interface to open and enter the data. When i open the excel file, user form will display first. I use this user form as interface. In this user form 3 user form has been linked through command button.

    Actually i have nearly 120 staffs across my country. All these 120 staffs are using this tools to enter the data in off line and share it with me through mail. I am download every sheet and consolidating using macro code and doing my analysis and report everymonth.

    Needed Requirement is:

    Is there any possibility to keep this excel file in "One drive" or "Server" and ask 120 staffs to do a data entry in that excel file. Then i can get the consolidated real time entry? Or else kindly suggest me something meets my requirements.

    I want my 120 staffs to access this excel file in online and i want to get the consolidated database.

    Thanks in advance and your small help will also be appreciated.

    Regards

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,759

    Re: How user Form can be accessed by multi user in online?

    I don't believe you can, using UserForm.

    If you have OneDrive, you may have access to MS Forms/Survey. Use this tool for data entry.

    Other alternative is to use SharePoint, or some other front-end that utilizes relational DB as backend.

    Excel, is not meant for data integrity control (rather it's designed for flexibility) and having that many user access file concurrently can cause major issues.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    321

    Re: How user Form can be accessed by multi user in online?

    Ultimately- You're going to want to use a real web server + database + server side scripting setup, what you're asking to do with excel is outside the scope of what excel can handle.

    I would recommend looking into an app called xampp (https://www.apachefriends.org/index.html) apache + php + mariadb, 1.) it's free 2.) very easy to setup and run, get your feet wet with web development and you won't regret it.

  4. #4
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    Re: How user Form can be accessed by multi user in online?

    Dear Mr. Poizhan,

    Thanks for your positive thoughts and showing me a way to do try something on it. I will try and come back if any support required. Thanks a lot again.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possible for real time / online user form based data entry
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2018, 02:07 AM
  2. Multi User Login Form - Help
    By tfilipe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-22-2018, 07:26 PM
  3. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  4. [SOLVED] Macro to record User Name and Duration user accessed file.
    By bajdr47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 04:14 PM
  5. Multi List Box in User Form
    By zimbo109 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 05-02-2010, 04:08 AM
  6. Create a user form with a multi-column list box
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2009, 11:33 PM
  7. how do i set up multi page user form
    By Davidrowland88 in forum Excel General
    Replies: 1
    Last Post: 03-03-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1