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?