trying Sendkeys in VBA for copy paste but not working

[snjpverma]

I am trying to copy and paste using Sendkeys but it doesn't work.

Sub trial()
Application.SendKeys "^C", True  'Pressing Ctrl + C to copy activecell

Application.SendKeys "%{Tab}", True 'Pressing alt tab to go to another excel 

Application.SendKeys "^V", True   ''Pressing Ctrl + V to paste in the Userform's textbox which is opened

End Sub

 

[kennypete]

I'm not sure why you'd want to use SendKeys. It's also not clear to me what you're trying to do, but perhaps it's something like this?

Sub SelectionToTextBox()
    TextBox1 = Selection.Value
End Sub

Where Sheet1 has the code and the TextBox you can see in the Worksheet is TextBox1.

 

[kennypete]

Hi @snjpverma did this work for your needs?

 

[snjpverma]

Thanks kennypete, for the response.

However, the excel in which the UserForm is situated is locked in such a way that the moment the UserForm gets loaded, all the instances of Excel gets locked. You can't even click on anything except the UserForm.

Anyway, I am no longer working for that project. So it's fortunate for me.
Have a great day!!