Is it possible to have text box value on a form results from the
combo
box value ?

I would like to use the vlookup formula; I used the following :


frmAREntry.txtreferenceamount.Value = WorksheetFunction.VLookup
(reference_vlookup, _
Worksheets("Data").Range("C11:H1100"), 6, 0)


Form name is frmAREntry
text box is txtreferenceamount


when combo box picks up the value it sits in range =
reference_vlookup


Can someone please help and if i have missed some info here please
let
me know


Thanks
NM