It gets sort of convuluded but here goes....

I have a list of products on a worksheet. When the user selects an
item from those products appearing in a user form based on that sheet,
the listindex value calls the product and the associated cost into a
"selection link" of two cells which are named a range. The product and
the cost are then entered automatically into column a and b respectively
based on that range.


--
novicevbaer
------------------------------------------------------------------------
novicevbaer's Profile: http://www.excelforum.com/member.php...o&userid=12567
View this thread: http://www.excelforum.com/showthread...hreadid=319425