You shouldn't need code for anything you described here. Set up the combobox
with the list fill range, if any. Set the linked cell to the desired cell.
Then, use the VLOOKUP command in another cell to look for the linked cell
from the combo box to look through the list desired and return the
appropriate information.

Example:
ListFillRange is H5:H7
Values to return based upon selection are in I5:I7
LinkedCell is F5
Range G5 formula is "=VLOOKUP(F5,$H$5:$I$7,2,FALSE)"

Hope this helps!

""PA via OfficeKB.com"" wrote:

I am trying to add a combobox that when you select from the dropdown menu,
the columns nextdoor automatically pull up corresponding data that is related
to the selection from the dropdown list. Does this make sense? What do I do
to set this whole thing up? (I don't know code).

Thanks.

--
Message posted via http://www.officekb.com