Question One:
Code:
'paste into a textbox 
Text1 = Clipboard.Gettext 

'get text from a textbox 
Clipboard.Settext Text1.text 

'copy a variable content to clipboard 
Clipboard.Settext MyVar 

'clear the clipboard 
Clipboard.Clear