userform update table based on 3 criteria

I use the following code to look up a value based on 3 fields (job number, month, year)

Please Login or Register  to view this content.

this will pull up the $value that matches that criteria. I would like to then be able to modify that value and UPDATE the value in the table . So basically it has to perform the same function but then enter the value within the "billingamount" text box.

any help is appreciated. thanks!

There may be better solutions but what I do in a case like this is add an extra column to the Listbox, fill it with the rownumbers of every record, then filter and afterwards you can use this number in yours Cells-statement to find correct row.
Would be something like.

Please Login or Register  to view this content.

To update ListBox code post example file with exact layout of your original file.

This should do it.