From your description, this may be more what you're after. I could be
wrong, after all this is my first time posting to a newsgroup. Here
goes (you'll obviously have to change the Userform & Textbox names, if
they are other than "Userform1" & "Textbox1":

Sub FormShow()
Dim CHOSENCELL As String
CHOSENCELL = ActiveCell.Value
UserForm1.TextBox1.Value = CHOSENCELL
UserForm1.Show
End Sub


Or if you're pasting from another applicaton. There's a command called
"GetFromClipboard" which you could look up in the Excel help files.