Complete the project of Posting VBA Code

Hello there

I am trying to post the a question to the ExcelTip Forum using this userform.

I managed to open the web page on the New Thread page, but i need a help how can copy the text inside the thread

i.e. need a vba code to copy the text to the new thread box ?

here are the codes:

'*Open Web Page
Private Sub PostVBA_Click()

'*Shows how to open websites using the FollowHyperlink method
    Dim strWebsite As String
    
    strWebsite = "http://www.excelforum.com/newthread.php?do=newthread&f=7"
                     
'* Open Web Page VBA ExcelTip
    ActiveWorkbook.FollowHyperlink Address:=strWebsite, NewWindow:=True
     
End Sub

' I write a text inside this TextBox1 and need to copy it into the new thread via vba code.....this is what i need ?your help would complete the code and make good pice.

please have a look at the same thread. Thank you

http://www.mrexcel.com/forum/showthr...24#post1442524