Private Sub TextBox1_Change() 'Dates
Me.ListBox1.Clear
For Each c In [Dates]
If UCase(c) Like UCase(Me.TextBox1) & "*" Then
Me.ListBox1.AddItem c
'Dates.Value = Format(Dates.Value, "dddd dd mmmm")
'Me.ListBox1.AddItem Format(c, "jjjj jj mmm")
'Me.ListBox1.AddItem Format(c, "dddd dd mmmm")
'ListBox1 = Format(ListBox1, "dddd dd mmmm")
End If
Next c
End Sub
Private Sub ListBox1_Click()
ActiveCell = Me.ListBox1
Unload Me
End Sub
Private Sub UserForm_Initialize()
Me.ListBox1.List = [Dates].Value
' ListBox1 = Format(ListBox1, "dddd dd mmmm")
End Sub