Your idea seems vague to me...seems pretty easy but not sure what you are up to...
There are experts in here who can help if you can explain what you want more clearly
for now...may be you can link by going in to properties....to the cell
or assign a code like..
cells(1).value = textbox1.value
I am not sure wat u're up as said...since you want range A1:A20 to be copied to a userform text box....
