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=http://img460.imageshack.us/img460/1844/user22cm.th.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=1...N2SQ7UAJKWMI68

[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)

"sknudson" <[email protected]> wrote in
message news:[email protected]...
>
> 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=1...N2SQ7UAJKWMI68
>
>
> --
> sknudson
> ------------------------------------------------------------------------
> sknudson's Profile:
http://www.excelforum.com/member.php...o&userid=30874
> View this thread: http://www.excelforum.com/showthread...hreadid=505523
>

[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 [email protected].

Sincerely,
Leith Ross

[sknudson]

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