Needs help with inputting the formula in VB

[jon151]

Hi all,

I have a user form that will enable user to enter a lookup based on the criteria reference no.
When the user click Search, all the records in relation to the reference no. will populate the fields and user can edit the data and press "Save" button once done. The "Save" button will then update the records accordingly.

I have to input two formulas to update a column in excel, those 2 formulas are:

1st Formula

Please Login or Register  to view this content.

and

2nd Formula

Please Login or Register  to view this content.

Now I want to convert the formula to VB so that when user click on the "Save" button, those 2 formulas will automatically update the field from the background.

I have the following update record code set - I tried to convert the 1st Formula

Please Login or Register  to view this content.

Then I got an error 1004 application-defined or object-defined error when running the Form.

Can anyone help me with getting the formulas to work?

Also I need help converting the 2nd Formula to VB.

Many thanks in advance for your reply and I really appreciate any help.

[protonLeah]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

In the mean time consider:
=IF(N3="","",IF(N3<=M3,"Yes","No"))

Please Login or Register  to view this content.