Point of sale system excel4/6/2023 ![]() ![]() ![]() ![]() bundle 3 items together for a set priceĢ) Buy X (SAME OR DIFFERENT) products from a selection of products and get them a set price - this would enable you do handle 'Buy get one free' kind of deals, '3 for 2' kind of deals and '2 CDs for £15' kind of deals The person who I am writing this system for has asked me if I could incorporate multibuy deals into the sytem, specifically:ġ) Buy X DIFFERENT products from a selection of products and get them a set price - this would enable you handle bundle deals eg. When the user has taken payment then a receipt is printed out and the sale's data is stored in another worksheet. When the user clicks a 'take payment' button on the worksheet I use a userform to inform them of sale total and for them to enter different payment methods / amounts. What happens is, when the user enters an item code in column A using VBA I look up the products details which are stored on a separate worksheet and copy across the item's price and tax code. I currently have an Excel worksheet which is used to hold the items in the sale: (It is long story as to why I am doing this and I know it is probably crazy using Excel and VBA as the basis for a point of sale system but it seems to be working!!) I am writing a Point of Sale system in Excel using VBA. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |