ComboBox Value

[faliero]

My ComboBox is filled with dates

Mar 00
Apr 00
May 00
Jun 00
Jul 00
Aug 00
Sep 00
Oct 00
Nov 00
Dec 00
Jan 01
Feb 01
Mar 01
Apr 01
May 01
Jun 01
Jul 01
Aug 01
Sep 01
Oct 01
Nov 01

I have a problem with dates after Dec 00, the date in Cells(1,18) doesn't match anymore after Dec 00 . I am using the following code

Cells(1, 18).Value = CapsuleStartComboBox.Value

thanks for any help

 

[Norie]

What do you mean they don't 'match'?

 

[faliero]

Sorry, I wasn't clear
I'm using

Private Sub CapsuleStartComboBox_Change()   
    Cells(1, 18).Value = CapsuleStartComboBox.Value
End Sub

If I change the combobox to Jan 01 I get Jan 05 in cells(1,18)

thanks

 

[rs2k]

Failero,
I have had similar problems with 'times' in a combo box, the way I got round it was to format the 'times' as text and when the data was sent to the worksheet it was converted back to a time format. Don't quote me, but, I think it has something to do with the way Excel handles dates, (I had 12:00 for midday, but the Cbox displayed it as 00:05, similar to your Jan 01 displaying as Jan 05)

This is the link,
http://www.mrexcel.com/board2/viewtopic.php?t=177387&highlight=

My VB is not brilliant, but I will try and help, if this is the way you want to go,

Cheers
Colin.

 

[faliero]

cheers mate
just what I needed!?!