Text box output linked to combo box value

N

Naeem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text box output linked to combo box value 0
txt box linked to combo box - help 1
Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
combo box 2
Combo box 0
Combo or list box 0
Active XText box vbcr shows symbol instead of an actual carraige return 2

Top