How to populate a date to a textbox by clicking on a calender image placed beside it?

[excel_sat]

Hi all,

I have 4 textboxes on my userform (Txtbox1,Txtbox2..)which have small calender images (img1.img2..) placed beside them.
What I need is... when i click on the calender image a calender should open up right below the image and when i select a date it should get populated in the textbox beside it.

I tried datepicker for this but it seems it is supported only in earlier versions of MS excel. I use MS excel 2007.

It would be good to have a function or sub for this as this might be used later in many pages of my project.

Could anyone please help me with this?

 

[Stridhan]

perhaps this could help you out
Excel Tips: Put a Calendar Date Picker on an Excel Worksheet

 

[excel_sat]

Thanks Stridhan for your reply.

but Iam not sure if datepicker would work if the user uses excel 2010 or later ones. currently Iam developing in excel 2007 so it works fine in 2007.
If there is any way that datepicker can be embedded into the project and given to user that would also work for me.

 

[excel_sat]

Hi.. I need help with this.

I have been searching since 3 days and couldn't find anything.. I want something other than datepicker.
If anybody could point me in the right direction it would be of great help

 

[MickG]

This is not perfect but is a self contain Calendar. Select date then, Textbox Icon for result in related Textbox. (Modify to suit)
https://app.box.com/s/l9fiunm4851t63x8lb57enu6qelj11s0