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