adding 'ComboBox2' data into subject headfing in email error please help

[Patriot2879]

Hi i hope you can help, i am tring to add the data entered into 'ComboBox2' into my subject heading in an email, i have tried the below code but i get an error, i really hope you can help me? thanks for your time.

aEmail.Subject = Range("ComboBox2").Value

 

[Patriot2879]

hji i have now put this in as a code but no joy, i want it to say in subject heading 'Today and what ever it says in the ComboBox1 in userform8, if you can help please

aEmail.Subject = "Today" & Range("ComboBox1").Value

 

[Fluff]

How about

aEmail.Subject = "Today" & Userform8.ComboBox1.Value

 

[Joe4]

That is not how you would reference a ComboBox value.
How you do it depends on what kind it is (Form Control or ActiveX Control).
See here: https://stackoverflow.com/questions/44083621/vba-how-to-reference-combobox-object

 

[Patriot2879]

that is great thank you, thanks again for your help , sorry about the duplication earlier today, won't happen again , your help is so greatly appreciated

 

[Fluff]

Glad we could help 7 thanks for the feedback