Sum Values in Command Text Box

[iaindowner]

I am trying to design a workbook to function as a till. I have a number of commandbuttons which relate to particular products. Originally when I clicked different buttons the product name appeared in a particular range in the next blank row with vlookup finding the price from a separate sheet however this only allows for a certain number of products to be listed before having to scroll.

I have tried using a command textbox which enables scrolling within the textbox however this does not make it easy to lookup and sum values.

Is anybody able to suggest a viable way of accomplishing this so that I will able to be able to click buttons, the button will insert the products in a list with the price to the right of the product so I am ultimately able to sum the prices.

Apologies for the complicated explanation. Happy to answer any questions

 

[dmt32]

Hi,
If developing a POS system from scratch maybe worth your while searching web for any opensource material to help in development of your project.

Here is one:EPOS 4 Excel - Home

No idea how good / bad it is - but always worthwhile doing a little research.

Hope helpful

Dave