Userforms + Listboxes

[sknudson]

I'm developing a system in Excel for a fictational computer store. Most
of its work is being done from a userform in list boxes which should
hold certain things (parts, software etc. See screenshot below). I have
three sub tasks which need to be solved.

1) How do I actually populate the listboxes? The data I need is held on
the 4th Sheet marked "Staff Only"
2) After populating the listboxes, the userform should place selections
on a within a certain range on the 2nd Sheet "Invoice"
3) After selections are placed onto Sheet2, the prices should be
displayed next to the selection which requires gathering data from
Sheet4. Which formula should be used?

I'd greatly appreciate all help possible.



'[img=[URL]http://img460.imageshack.us/img460/1844/user22cm.th.jpg[/URL]]'
(http://img460.imageshack.us/my.php?image=user22cm.jpg)

 

[Leith Ross]

Hello SKnudson

The screen shots are difficult to read. Could you post a Zip version of
the workbook instead? If I can see it better then I sure I can answer
your questions.

Thanks,
Leith Ross

 

[sknudson]

Hi Leith Ross,
Thank you very much for your prompt reply.

An uploaded copy of the workbook is available at
http://s39.yousendit.com/d.aspx?id=113TW9J8K1K1N2SQ7UAJKWMI68

 

[Leith Ross]

Hello SKnudson,

I downloaded the file no problem. Thank you. I will look this over and
let know you what I have done.

Sincerely,
Leith Ross

 

[Bob Phillips]

A file is at http://cjoint.com/?bBba1KUeNc

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Leith Ross]

Hello SKnudson,

I coded 3 macros into your workbook. The macro GetProductGroups reads
through the database on "Staff Only". This collects the product
descriptions and prices for a group of products like "Processors". If
you add any new groups, make sure the group name is in "Blue" font
(ColorIndex 5) and the last entry is a blank line.

The LoadProducts macro places the product descriptions and prices into
2 columns of the ComboBox using the group name. The Click event of each
ComboBox calls another macro that places the product in the cell you
specifiy with the price in the cell to right of the description.
Currently I have set the first cell at "A10".

This should allow you plenty of flexiblility as your database grows. If
you have questions you can contact me via email (e-mail address removed).

Sincerely,
Leith Ross


+-------------------------------------------------------------------+
|Filename: green1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4274 |
+-------------------------------------------------------------------+

 

[sknudson]

Many, many thanks for both of your solutions. They work perfectly.