Using a Dtpicker to select dates

[grahamf]

Hi there

I am using a dtpicker in a spreadsheet which is to be used as a timesheet. The dtpicker is being used to aid user day selection and to ensure the date cell is populated with a date in a text format e.g. '2015/07/01 as this data is exported to a csv file to be imported into another system.

The correct date cell is selected and then the dtpicker is used to select a date which then populates the active cell (see code below)
Private Sub DTPicker21_Change()
ActiveCell.Value = "'" & Format(Me.DTPicker21.Value, "yyyy/MM/dd")
End Sub

The one issue is this only works when the date in the dtpicker is changed - so if 2 consecutive date cells are to have the same date the second cell is not populated unless the user changes the date and changes it back.

Any suggestions around this?

I hope this makes sense.

Thanks
Graham

[:) Sixthsense :)]

Replace

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[grahamf]

Hi Sixthsense

Sorry this does not change anything - same result