So it seems as though you either have to click on the cell to activate the userform or you have to paste into a column that has a userform behind it. Hummmm....
If those are the only ways I'll see if I can work with that... does the userform coding have to be in the same spreadsheet as the data it's manipulating?