So I have just tried and using the following code - works 
As a module wide variable
Dim adatearray(1 To 31, 1 To 3) As Variant
In the initialize
For I = 1 To 31
adatearray(I, 1) = I
Next I
For I = 1 To 12
adatearray(I, 2) = Worksheets(WS3nam).Cells(I + 2, 2)
Next I
For I = 1 To 4
adatearray(I, 3) = Year(Now) - 2 + I
Next I
in the ok button sub
Adate = adatearray(ListBox5.ListIndex + 1, 1) & "-" & adatearray(ListBox6.ListIndex + 1, 2) & "-" & adatearray(ListBox7.ListIndex + 1, 3)
Thanks again for your help
Bookmarks