search, select row via listbox, then edit room number cell of selected row

  • Hey everyone!


    I am hoping someone can help me out with this issue or point me in the right direction of how I should go about doing this.


    Right now I have several sheets that each contain their own information. I have a listbox on my userform that is populated with the data from a specific sheet based on the value the user selects in the combobox (the value is the sheet name, hence that sheet is selected). I also have a search box that allows me to search the mastersheet (information from each individual sheet was collected and put into one mastersheet) for any cell that contains a partial match.





    What I would like to do is:


    1) Utilize the search box to find the specific item
    2) locate that item within the mastersheet AND the individual sheet it originally resided
    3) find the exact row and edit the value of column 5



    essentially I am allowing users to edit the room number that this item is moving to. I want them to click the item they're relocating, click edit, type in the new room its going to and have each sheet automatically update the correct cell.




    If anyone has any ideas that would be wonderful as I am still quite a beginner when it comes to coding any advice or input is welcomed and appreciated!


    Mike

  • Re: search, select row via listbox, then edit room number cell of selected row


    Hi Mike - You have three specific tasks... in what amounts to a small project. I would suggest maybe this is a job for our hire help forum.


    http://www.ozgrid.com/forum/forumdisplay.php?f=105



    The only vague advice I could offer on your requirements:




    1) Utilize the search box to find the specific item
    Use a VBA InputBox to capture user data: https://msdn.microsoft.com/en-…rary/office/ff839468.aspx


    2) locate that item within the mastersheet AND the individual sheet it originally resided
    Use a loop with to go through each worksheet: https://support.microsoft.com/en-gb/kb/142126


    And use the VBA ".find" method to find information you need, like the one here: http://www.ozgrid.com/forum/showthread.php?t=27240


    3) find the exact row and edit the value of column 5
    As mentioned above, the VBA .FIND method should point you to the data you want, and either use the Inputbox again to present the current data to the user and update it, or create a new user form.


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

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