Multicolumn Listbox and ordinary listbox

[Ron_D]

First, I would like to thank you guys in advance for the help I'm about to ask
I have a userform with a multicolumn listbox who's rowsource is a named range of cells, and a simple listbox. Depending on the item I select on this multicolumn listbox will determine the controlsource of the ordinary listbox. I just need a means to determine the row of the selected item and use the CELLS method to offset to the correct column. Also, the named range will move so I need a means of determining the upper left cell coordinate of the named range, determine the row offset using Listindex method, and use CELLS to offset to the column

Thanks again for the help
Ron_