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

It is not necessary to keep posting the same message. If someone knows how
to help, they will respond. Be sure your problem is clearly stated so that
those who review it can understand it. Remember, we cannot see your monitor
screen.


"Naeem" wrote in message
...
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