Hi DonB,

Another approach might be to use the RefEdit control (say this is named 'refedit1'), assuming that your macro will be using the cell value as input.

So If you wanted to set a variable (named var1 below) to whatever was in the cell, then say

var1=range(refedit1.text).value

This line will return the value in the cell range selected.

I hope this is helpful.

SuperJas.




----- DonB wrote: -----

I would like to right click a worksheet cell, copy its
data, open an existing/"homemade" UserForm, select a
TextBox on it, right click, then paste. How? Any ideas
would be much appreciated.