Assuming form is a userform:

Private Sub Combobox6_click()
' code that places the value in textbox2 based on values
' in 6 comboboxes
set rng = Worksheets("Sheet2").Cells(rows.count,4).End(xlup) .offset(1,0)
rng.value = Textbox2.Value
End sub

--
Regards,
Tom Ogilvy



"dthames" wrote in
message ...

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