loststudent
New Member
- Joined
- Jan 25, 2018
- Messages
- 7
Hi everyone!
I'm making a company's stock application in VBA.
I have a userform that adds orders details (including unit prices) to a sheet and I want the unit price added to be updated on another sheet (with the current stock). The updated cell would have the value added through the userform, but only if there is an order entry regarding it. Otherwise, the value should remain the same.
I tried using IFSUM, so that if it can find the product in the range of unit prices on the other sheet, the cell would be updated. But I need a value_if_false that would make no change to the cell and, as I found out, there is no way to do that with formulas (correct me if I'm wrong).
I don't know how to do this with VBA either, so some code would be very appreciated (instructions needed too, I'm not a complete beginner, but not a pro either).
Thank you!
I'm making a company's stock application in VBA.
I have a userform that adds orders details (including unit prices) to a sheet and I want the unit price added to be updated on another sheet (with the current stock). The updated cell would have the value added through the userform, but only if there is an order entry regarding it. Otherwise, the value should remain the same.
I tried using IFSUM, so that if it can find the product in the range of unit prices on the other sheet, the cell would be updated. But I need a value_if_false that would make no change to the cell and, as I found out, there is no way to do that with formulas (correct me if I'm wrong).
I don't know how to do this with VBA either, so some code would be very appreciated (instructions needed too, I'm not a complete beginner, but not a pro either).
Thank you!