I am tring to add dates (today & tomorrow) to a combobox.
The first date is showm as 30/4/08, second date is shown as 5/1/2008. Second date should be 1/5/2008 for me in the UK.
Not sure if this is a problem with excel or vba ?
Any help would be appreciated.
Code:
Private Sub userform_Initialize()
today = Date
tomorrow = today + 1
ComboBox1.AddItem today
ComboBox1.AddItem tomorrow
End sub
The first date is showm as 30/4/08, second date is shown as 5/1/2008. Second date should be 1/5/2008 for me in the UK.
Not sure if this is a problem with excel or vba ?
Any help would be appreciated.