G
Greg B...
I want a upcomings event diary to show me what is coming up in the next
month, It will not allow anymore than 2 weeks. Is there any way to change
this
Also in the listbox on the userform it show the date time and event in 3
columns how do I get the 1st column to show the date in the dd mm yyyy
format
Thanks again
Greg
Private Sub UserForm_Initialize()
Do Until Sheet1.Range("a2").Offset(counter).Value > Now + 14
counter = counter + 1
Loop
UserForm1.ListBox1.ColumnCount = 3
UserForm1.ListBox1.List() = Sheet1.Range(Cells(2, 1), Cells(counter,
3)).Value
End Sub
month, It will not allow anymore than 2 weeks. Is there any way to change
this
Also in the listbox on the userform it show the date time and event in 3
columns how do I get the 1st column to show the date in the dd mm yyyy
format
Thanks again
Greg
Private Sub UserForm_Initialize()
Do Until Sheet1.Range("a2").Offset(counter).Value > Now + 14
counter = counter + 1
Loop
UserForm1.ListBox1.ColumnCount = 3
UserForm1.ListBox1.List() = Sheet1.Range(Cells(2, 1), Cells(counter,
3)).Value
End Sub