Date Picker to change date

Hi,

Please find attach sheet.

I have a Demo sheet . In it i have "Main" workbook which contains a button as"Change Date" which when clicked will bring up a calender popup and when the date is selected , it change the date in "abc" sheet cell C1 to next week date (i.e. from 14-June-2015 to selected date.)

I am attaching the addin which will be helpful. Am am not sure as i am a newbie.

Adding the Demo sheet and Add-in below-

Pop-up_Calendar_Add-In.zipDemo.xlsm

Thanks in Advance :-)

Regards,
MS

Hello
For this you probably need to add the Date Picker active x control and link it to the 'abc' sheet cell C1. You can set the command button to make the control visible = false or true. See link:

http://www.fontstuff.com/excel/exltut03.htm

DBY