Hi everyone,
hope y'all doing great during this pandemic..
I have a problem I don't know how to solve.
My homework is to program a vending machine via VBA. I have to do two kinds of interfaces, one only for the costumer (User Interface) and one only for staff (Service Interface). My problem is, that every time someone buys from the machine, the inventory is reducing by the amount that person is buying, but I don't know how I'm supposed to transfer that into the Excel sheet (Service Interface).. Do you know what I mean? After every purchase a staff can look into the Service Interface to see how much goods are still available.
I really hope someone can help me with that bc my brain can't handle that anymore haha..
Thankss
Bookmarks