datepicker how to add into subject of email

[Patriot2879]

Hello, i have the code below where i am tring to add the date into my subject, i have added the date picker in Excel called DtPicker1, but when i have added into the code below it doesnt work and i get an error can you help me please?

aEmail.Subject = "Saturday  - " & Range("B1").Value & " " & Range("DtPicker1").Value

 

[Patriot2879]

hi sorry i forgot to add that where the dtpicker1 is located is in a sheet called 'Buckinghamshire'

 

[Patriot2879]

hi just wondering if you guys have any ideas at all please, what i want is the date to show in the subject of the email , so i have added the date picker to a sheet called 'Buckinghamshire' but the code above isnt working i hope you can help me please?

 

[Logit]

.
Using the DatePicker may be overkill for what you are attempting ?

If you use this formula in B1 =TODAY() and format the cell as : DATE / *Wednesday, March 14, 2001 by right clicking the cell and choosing FORMAT / DATE.

Will this work for you ?

 

[Patriot2879]

thats great thank you

 

[Logit]

.
You are welcome.