M
miker1999
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=Departmen
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
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=Departmen
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