Date Format Change on a Userform

[patteb]

How can i cahnge the date format on a userform?

i have a calander pop up when the command button is pressed, when the date is selected it goes into the text box in the mm/dd/yyyy format. i want to change it to a dd/mm/yyyy or a DD MMM YY format. nothing has worked that i tried.

 

[Rick Rothstein]

How can i cahnge the date format on a userform?

i have a calander pop up when the command button is pressed, when the date is selected it goes into the text box in the mm/dd/yyyy format. i want to change it to a dd/mm/yyyy or a DD MMM YY format. nothing has worked that i tried.

You did not specify where the date from the calendar popup is located at, so let's assume D is the value being returned from your calendar popup, try assigning this to the TextBox...

Format(D, "DD MMM YY")

 

[patteb]

Hi Rick

When the date is selected from the calendar the textbox beside the command button is populated, its textbox3 that is populated and the calander name is MonthView1.

does this make more sense?