Combo Box issue

[JO505]

I have a combo box (Active X) on a sheet that should display a 4 digit year from a list named "Year". Everything works as it should with the exception of the date displayed from the list after it has been selected.

when you access the list the combo list shows a list of the years from the list, selecting a year will put the selected year in the 'active cell' (Z1). I can then use this for a Vlookup function to access the proped data. The problem I am having is after the date is selected the chosen date (Year) is not displayed. As an example if I select 1994 as the year 1994 is displayed in cell Z1 and using the code shown below I am able to access the vookup data but the date shown in the combo box is shown as 6/16/1905 instead of 1994. I have tried changing the format in the cell and in the code but to no avail. Any suggestions?

Please Login or Register  to view this content.

As I said everything works fine its just the selected year does not show up properly.

Jim O

[CostCare]

Hi,

Just loose the code? . works for me!

Regards, Bart

[CostCare]

Only use this part of code:

Range("Z1") = ComboBox1.text

[JO505]

Thanks to both for the responses.

I have it working now.

Jim O