Help in VBA

laavita

laavita

New member
Joined
Nov 12, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
360
Hi! I'm working on this program, and I don't know why there is an error saying Expected End With. I'm new to VBA or any computer programming. Will you please check on the codes I made too if there might be future problems that may occur after solving Expected End With?

Thank you!
 

Attachments

  • Lei Bellisima - Inventory Management System.xlsm
    180.3 KB · Views: 3
Run-time error 1004

Hi I've solved the END WITH issue I think. But now there is a new problem
 

Attachments

  • Lei Bellisima - Inventory Management System.xlsm
    225.7 KB · Views: 5
The UserForm code is erroring at:

Code: 
Inv_sh.Range("F1").Value = "=VLOOKUP(A2,Product_Master!B:G,3,0"

Fails At 2.jpg

Fail Message.jpg
 
You must log in or register to reply here.
Back
Top