+ Reply to Thread
Results 1 to 4 of 4

Homework - Vending Machine Problem!

  1. #1
    Registered User
    Join Date
    Berlin, Germany
    MS-Off Ver
    Microsoft Office 365 ProPlus

    Homework - Vending Machine Problem!

    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..

    Last edited by Richard Buttrey; 11-21-2020 at 04:04 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac

    Re: Vending Machine Problem!

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching we require the title of your post should clearly indicate you are seeking coaching or tutoring help. Any forum members who are willing to assist as a tutor will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored. I'll adjust the title for you since this is your first post.

    It would also be useful if you would explain how familiar you are with VBA.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    market harborough, england
    MS-Off Ver
    Excel 2010

    Re: Homework - Vending Machine Problem!

    A elementary start - stock into the machine - stock out - now expand it with basic sales minus costs = gross profit.
    Use your imagination the combinations are endless.
    Attached Files Attached Files

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019

    Re: Homework - Vending Machine Problem!

    Another option to play around with...
    As torachan says...combinations are endless...
    Press green button next to item name...
    Attached Files Attached Files
    Last edited by sintek; 11-24-2020 at 02:03 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel macro running on machine, but not on other machine. Language setting?
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2017, 09:09 AM
  2. Working code on my machine is returning out of range error on another machine.
    By je.suis.ketan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2012, 11:51 PM
  3. Macro runs fine on my machine; won't run on another user's machine
    By brl8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2010, 03:16 PM
  4. Replies: 2
    Last Post: 03-01-2006, 12:25 AM
  5. [SOLVED] Reference & update destin. cells on 1st machine from source workbook on 2nd machine.
    By eastside877@yahoo.com in forum Excel General
    Replies: 6
    Last Post: 02-28-2006, 01:20 AM
  6. Replies: 0
    Last Post: 07-06-2005, 10:05 PM
  7. [SOLVED] where can I get a template for excel to track vending machine tak.
    By templates in forum Excel General
    Replies: 0
    Last Post: 01-08-2005, 11:06 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1