Search and Edit excel data in a userform

  • Hi everyone!

    I am really hoping someone can help me with this as I have sifted through a lot of unanswered or unclear threads regarding this.

    Basically, I work in a small team of 5 people, but each of us is very busy and get emails from our manager asking us to complete different tasks. I have made a userform in excel for our manager to create the tasks in and put all the details in sheet1. This creates each separate task on a separate row. Now I want each of my colleagues to log into the sheet and be able to retrieve a task with the same userform. I am giving each task it's own ID, so I want to be able to search by this and the userform will be populated with the task details. I also have combobox's with the status of each task (Completed, In progress etc.) I want to be able to change these in the userform too.

    I would do this in access, but we don't have this on our work laptops.

    My code for the userform up to now is:

    Any help at all would be appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!