Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender Help
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calender | Excel Worksheet Functions | |||
Calender | Excel Discussion (Misc queries) | |||
pop up calender | Excel Discussion (Misc queries) | |||
CALENDER | Excel Discussion (Misc queries) | |||
Calender Help | Excel Worksheet Functions |