Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 46

Thread: Update cell after update from userform

  1. #31
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    916
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update cell after update from userform

    hi Dave would it be easy to amend the link to the 'Data' sheet? to C:\Users\s21375\Desktop\Book1.xlsm and sheet in book1 is called 'data'

  2. #32
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,090
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Update cell after update from userform

    Quote Originally Posted by Patriot2879 View Post
    hi Dave would it be easy to amend the link to the 'Data' sheet? to C:\Users\s21375\Desktop\Book1.xlsm and sheet in book1 is called 'data'

    Is this question related to your latest thread: https://www.mrexcel.com/forum/excel-...rform-use.html

    Short answer not easy especially if you are thinking of creating template copies of your workbook for multiple users where they read / write data to central workbook (database) over a corporate network but is doable.

    This is a much better solution than sharing a workbook (which is best avoided) but does require some extensive coding to manage.


    Dave
    Last edited by dmt32; Sep 19th, 2019 at 09:55 AM.

  3. #33
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    916
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update cell after update from userform

    Hi Dave yes related to my other thread, just another idea thought that this might be doable if the data is in another workbook and userforms are separate?

  4. #34
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    916
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update cell after update from userform

    Please could you advise how I could make template copies of m workbook for multiple users where they read / write data to central workbook (database) over a corporate network. this would be amazing.

  5. #35
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,090
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Update cell after update from userform

    Quote Originally Posted by Patriot2879 View Post
    Hi Dave yes related to my other thread, just another idea thought that this might be doable if the data is in another workbook and userforms are separate?
    You are not really meant to ask same question in two threads (I think)

    With multi users, having template copies of a workbook connected to a database (Access ideal or another workbook will work) is the sensible approach but it does involve much more coding to manage. Also, data copied to master workbook from one user, other users with their templates open will not get real time updates but will have to refresh each time to see changes.

    Worth noting that whilst users need read / write access, you cannot have the master workbook open in read / write mode.

    Dave

  6. #36
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    916
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update cell after update from userform

    Hi Dave, what would you recommend? and how would I do this? sorry I thought my other thread was separate to this thread as different to the original subject.

  7. #37
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,090
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Update cell after update from userform

    Quote Originally Posted by Patriot2879 View Post
    Hi Dave, what would you recommend? and how would I do this? sorry I thought my other thread was separate to this thread as different to the original subject.
    Its a similar subject line which a MOD may (or may not) have a view on.

    It it was a project I was doing I would connect template copies to a central database (Access ) but you can use another workbook as a simple database.
    I have done many of these in past & it can be a lot of work.

    If this is an approach you want to take you may do well to head to the Access forum & see if people there can assist. Or if want to use another workbook then create copy of your data tab & save it as separate file on shared network.

    You then need to develop code for the template copies to

    Open workbook read only to extract data to your table & close it

    Open workbook read / write to write data to it save & close

    Included in code you would need functions to manage errors & conflicts from other users amongst other things

    And repeat what I said last time, you cannot have a master workbook open read / write whilst others need to write data to it also, they will not see real time updates.

    Dave
    Last edited by dmt32; Sep 19th, 2019 at 10:40 AM.

  8. #38
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    916
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update cell after update from userform

    Hi Dave, ok thank you for the update what I would probably need is simple database in another workbook an make templates of the userform. but I don't have any idea on how to do that way over my had , also would it be possible o say when someone else is in another userform?

  9. #39
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,090
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Update cell after update from userform

    Quote Originally Posted by Patriot2879 View Post
    Hi Dave, ok thank you for the update what I would probably need is simple database in another workbook an make templates of the userform. but I don't have any idea on how to do that way over my had , also would it be possible o say when someone else is in another userform?

    Search the net, examples are out there

    With template workbook you would not need to know if user(s) had their copies open if fact, they can leave them ope all day if want.
    The one you cannot have open is the database workbook read / write mode. Only the code in template copies should do this.

    Dave

  10. #40
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    5,090
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Update cell after update from userform

    Quote Originally Posted by Patriot2879 View Post
    Please could you advise how I could make template copies of m workbook for multiple users where they read / write data to central workbook (database) over a corporate network. this would be amazing.
    I found some spare time & decided to have a further look at your project & this request to share across network & think that as you a are using a fixed matrix for your data it mau be a little easier to manage with multi users than I first thought.

    A possible solution would be to link the users template workbooks to a master (database) which when they update, changes should be reflected on other users copies. This process would all be managed by VBA code but idea would need further development & tested over your network.

    Dave

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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