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]'
(http://img460.imageshack.us/my.php?image=user22cm.jpg)


--
sknudson
------------------------------------------------------------------------
sknudson's Profile: http://www.excelforum.com/member.php...o&userid=30874
View this thread: http://www.excelforum.com/showthread...hreadid=505523