txt box linked to combo box - help

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
 
J

JLGWhiz

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.
 

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

combo box 2
combo box linked to named range 4
combo box - last value 2
Choose a value from a combo box based on a text box 0
User Form / Text Box / Combo Box 7
Worksheet change event with cell linked to combo box result 5
code to sum 8 textboxes 4
Combo Box / VLOOKUP 6

Top