HELP PLEASE RUN TIME ERROR 1004

[lavita17]

Hi! I'm having a problem with running my macros. Can you please help? It kept on saying eun-time error 1004. And going to the code where you should run the userform.

Thank you for all your help!

[#2]

@lavita17 

In the lines

    Inv_sh.Range("F2").Value = "=VLOOKUP(A2,Product_Master!B:G,4,0"
    Inv_sh.Range("G2").Value = "=VLOOKUP(A2,Product_Master!B:G,5,0"

the closing parenthesis of the VLOOKUP function is missing. Change the lines to

    Inv_sh.Range("F2").Formula = "=VLOOKUP(A2,Product_Master!B:G,4,0)"
    Inv_sh.Range("G2").Formula = "=VLOOKUP(A2,Product_Master!B:G,5,0)"

(I used Formula instead of Value, but that's just a preference, for clarity)