VBA, Email sending out from Excel question, please help :)

[XstarWake]

Hi,

I was able to create a button that send an email out to a particular email from Outlook email.

What i want to accomplish is :

Have a text field that i want to put in the Email_Subject information in there, once entered in the textfield, saved in a value and and i can call that value from my VBA code
Exemple : I have a Dim Email_Subject As String already, but its currently hard coded in the code as : Email_Subject = "Whatever email subject i want"
I want to change the value of Email_Subject with the one ive put in the text field.

Can anyone Help me please?

Thank you for all your help,

[XstarWake]

Like, can i just do a button, that ask for the subject line text as a pop-up, they i enter what i want, and save that info in a variable, then i call that variable?

[XstarWake]

If i want to make a button that ask for the subject line, does it need to be a function, not a Sub?

[XstarWake]

Got it!!!
I got the subject line to work!!!

[XstarWake]

got it for subject line, email from, who want to get CC or Bcc...

Now i want to set the body of the email but, with only a line, its not going to work. I need to have a bigger field and been able to write multiple lines...

Any suggestion?

[XstarWake]

no one? like a textarea or something...

[XstarWake]

lol i guess no one able to help a newbie in VBA hein??