Development tool,Excel,GUI
 

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

Hi Brian,

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

http://tinyurl.com/4qus9


---
Regards,
Norman



"BrianG" wrote in message
...
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

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

"Norman Jones" wrote:

Hi Brian,

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

http://tinyurl.com/4qus9


---
Regards,
Norman



"BrianG" wrote in message
...
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

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 he

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

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

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



BrianG wrote:
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

"Norman Jones" wrote:


Hi Brian,

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

http://tinyurl.com/4qus9


---
Regards,
Norman



"BrianG" wrote in message
...

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





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html