ExcelBanter - Userform w/ Multiple listboxes that link

Hello,
I am now about to experiment into the wonderful world o
Userforms....and I'm nervous.

Currently, I have the validation set up on 2 columns that link. Th
first column is Department and the second column only shows Position
available in what was selected in Department. I use VLOOK to accomplis
this (=INDIRECT(VLOOKUP(F4,DeptLookUp,2,0))....F4=Depar tmen
selected...

I have the first listbox with RowSource = Department (which is the nam
of the array that holds all the departments). How do I link this to th
second listbox and only populate and list the Positions for tha
Department? Is this possible?

Thanks a bunch

--
Message posted from http://www.ExcelForum.com