how to popup calendar in textbox in userform excel2007

[Gnanaprakash]

i have one problem how to popup calendar in textbox in userform excel2007

 

[Luke M]

With your userform, right-click on the Toolbox (to add controls). Select Additional Controls, and then check this one:

You can then add the Date picker to your user form.

 

[Gnanaprakash]

Thank for Helping I am using Excel-2007 in that there is no microsoft date & time picker

 

[Luke M]

Looks like this is a similar problem/solution:
http://answers.microsoft.com/en-us/...-control/6f2b489f-2ba3-4133-9b1a-61cc94a3654c