How to Add a date in a TextBox from a CalendarDatePicker in VBA

Hi

I'm trying to get a date from a datepicker calendar to input into a userform textbox.

I have a TextBox and commandbutton next to it, when the commandbutton is clicked the calendar userform I created loads up.

I just can't seem to find the code to get the date selection to show in the textbox - Does anyone know how to code this?

Any help would be great!

Thank you all!

Originally Posted by mehmetcik

I also have 2013 but have no datepicker. I may have to revisit that.

When I had a datepicker

I used the Datepickers change event

NB: Pseudocode:

Please Login or Register  to view this content.

Thank you for your response Mehmetcik.

Sorry I should have stated I'm actually using Office 2007/2010 for this now userform - this is how I found the datepicker calendar.

Where does that code go?

Thanks again!

Thanks for your help. I've given this a try but its still not showing a date in the textbox when I click on the date in the pop-up calendar.

I've looked all over the internet and the only code I found was for adding the date to a cell in a worksheet, not a textbox.

Any other suggestions?

Thanks again!

Originally Posted by mehmetcik

are you using

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

?

Hi

I've tried both but neither are working...

Thank you