Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,259
- Office Version
- 2010
- Platform
- Windows
Hi please can you help me i have a button which when clicked sends an email , but in the subject line i want it to copy what it says in my dropdown box in userform8 the drop down box is called 'ComboBox1' i have tried the code below but it seems not too work, please can you help me? i am still learning thank you in advance.
Code:
aEmail.Subject = "Today" & Range("ComboBox1").Value