chardy1983
12-04-2015, 05:07 AM
Hi all,
I have attached the spreadsheet I am working through. I have completed must of the VBA I require, however, I am stuck on the macro to amend a PO number.
Once the PO book has open PO's, I have a button, which enables the user to amend one of the generated PO. The way I have gone about this is, to bring up a user form to type in the PO number that needs amending, this will then bring up the amendment form.
I cannot seem to find any VBA code which can find the PO number and then replace with details from amendment userform.
Can anyone help?
I have attached the spreadsheet I am working through. I have completed must of the VBA I require, however, I am stuck on the macro to amend a PO number.
Once the PO book has open PO's, I have a button, which enables the user to amend one of the generated PO. The way I have gone about this is, to bring up a user form to type in the PO number that needs amending, this will then bring up the amendment form.
I cannot seem to find any VBA code which can find the PO number and then replace with details from amendment userform.
Can anyone help?