If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Complete the project of Posting VBA Code

Thread starter hmk
Start date Dec 16, 2007

hmk

Active Member

Dec 16, 2007

Hello there

I am trying to post the a question to the MrExcel 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:

Code:

'*Open Web Page
Private Sub PostVBA_Click()

'*Shows how to open websites using the FollowHyperlink method
    Dim strWebsite As String
    
    strWebsite = "http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10"
                     
'* Open Web Page VBA MrExcel
    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.

Last edited: Dec 16, 2007