using a vlookup to enter text into rows beneath the vlookup cell

R

Roger on Excel

I would like to have text entered into rows beneath a vlookup cell from which
the text is selected.

Each time i select the text in the vlookup, i would like the new text to be
entered below the previous selected text

There is code on the following helpful link that places text in an adjacent
cell, but ideally i need the text to be added in rows beneath the vlookup cel

http://www.contextures.on.ca/excelfiles.html#UserForm

see DataValMultiSelect

Can ayone help?
 
J

Joel

Something like this

Application.EnableEvents = False
If Target.Column = 3 Then
If Target.Value = "" Then GoTo exitHandler
If Target.Offset(1, 0).Value = "" Then
Target.Offset(1,0).Value = Target.Value
Else
Lastrow = target.end(xldown).row
Newrow = Lastrow + 1
cells(NewRow,Target.column) = _
Target.Value
End If
End If
 

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

Top