Development tool,Excel,GUI

[Guest]

I am looking for a suggestion of a development tool to use with Excel. My
friend is using Excel for his Inventory Control and Price Sheet. I need to
put a GUI on the spread sheet for Price Quotes and Inventory Control. VB,
VBA, Macro, ?. I have some programming experience. My friend needs
something quick and simple. My requirements are the same.
Thanks,
Brian

 

[Norman Jones]

Hi Brian,

Gord Dibben's response to an earlier question may well be of help:

http://tinyurl.com/4qus9

 

[Guest]

This was helpful when providing a hard copy. Thanks. An additional
requirement is an application that will allow a cashier to lookup a product
(from the backend Excel spreadsheet), enter a quantity, and see the
calculated price (POS app).
Thanks,
Brian

 

[Debra Dalgleish]

Create a list with product names in one column, and prices in the next
column, e.g.:

Product Price
jacket $25

Then, on another sheet, you can create a dropdown list of productss by
using data validation. There are instructions here:

http://www.contextures.com/xlDataVal01.html

To return the price for the selected product, you can use VLookup
formulas. There are instructions here:

http://www.contextures.com/xlFunctions02.html