I know more VBA than Excel, so I need help on a high level to know the
methods you might use.

Similar to the Lookup function I need to fill in a cell from another
workbook or worksheet. I need to be able to do something like: open a
form, select some filtering options (categories), then select an item
from a narrowed list. The selected value would populate the cell.

One column of cells would be populated one cell at a time, based on the
user decisions. A simple example would be to select a city from any
where in the world. You might want to select the continent, select the
reagion/nation, state/area, then the city. I think I can manage a good
part of it in VBA but how to connect it to the cell in Excel is what I
am lost.

Thanks,
Dan


--
dthames
------------------------------------------------------------------------
dthames's Profile: http://www.excelforum.com/member.php...o&userid=28793
View this thread: http://www.excelforum.com/showthread...hreadid=484821