Calender Help
I selected the whole column and in the custom tab I typed dd/mm/yyyy
It changed it on the worksheet but when I ran the macro for the listbox it
just showed it as mm/dd/yyyy
I just cant see why it would happen Here is all the code in this workbook
Sub run()
UserForm1.Show
End Sub
Private Sub CommandButton1_Click()
UserForm1.Hide
End Sub
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
The Userform1
just has a listbox and command button
I cant see why at why it dont work
Thanks
Greg
|