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" <(E-Mail Removed)> wrote in message
news:5287540B-CA43-45BA-B51A-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:5287540B-CA43-45BA-B51A-(E-Mail Removed)...
> >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 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



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" <(E-Mail Removed)> wrote in message
>>news:5287540B-CA43-45BA-B51A-(E-Mail Removed)...
>>
>>>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