Hi, i'm new to userforms and is struggling to do a matching / vlook up formula. Attached is the spreadsheet. It's only a snapshot of the spreadsheet, as i have lots and lots of code, and the actual line items are over 500 lines, with at least 20 providers, across many months. What the code is meant to do, is allow the user to edit and save any changes in the form, into the sheet INPUT. CODE is where all the naming conventions are saved.
In the Start Tab of the Userform, I want the user to type in a User ID into a textbox, choose a date (calendar button), and status (combo list), which will make the spreadsheet return the value (Accept Tab in the UserForm) that is in column D (name of company) and/or cboCompany (if status = accepted).
Could someone please help him how I can go about returning a value into txtCompany and txtPrice (in dollar format) where Unique ID matches what is in txtID, Date matches txtDate, and Status matches (cboStatus).
Many thanks in advance.
Note. I have incorporated the calendar code from elsewhere (author noted), and it is not mine.
Bookmarks