View original (French)

VBA Date Format English/French

Solved
Varin -  
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   -
Hello,

I would like to display a date input box in the format "dd/mm/yyyy".

When the user enters the date in the specified format, this date is displayed in the file in the format "mm/dd/yyyy".

-----------------------------------------------------------------------------------------
ActiveCell.FormulaR1C1 = InputBox("Enter the Date in the format dd/mm/yyyy")
Selection.NumberFormat = "dd/mm/yyyy"
-----------------------------------------------------------------------------------------

Do you have any ideas to help me? Thank you in advance.

4 réponses

Réponse 1 / 4
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 771
 
Hello,

Try this: 
Sub test() Dim myDate As Date, strDate As String strDate = InputBox("Enter the Date in the format dd/mm/yyyy") myDate = CDate(strDate) ActiveCell.Value2 = myDate End Sub


--
Before, I never managed to finish my sentences... but now I
1