gussi
08-01-2007, 05:09 PM
Hi guys,
I?m having problem with date & time.
I Have ? Combo box (Forms) which i?ve set up so I can choose date back in time from Data which i have in one Sheet.
Dim index As Integer
index = Cells(2,7)
Dim ticker As String
ticker = Cells(index + 1, 6)
In the combo box. I right clicked and picked the series of my dates and set the other thing as the index. Then i can click on the side of the combo box and choose these dates.
So when I?ve chosen the date, let?s say 1.4.2006 then i have to click on a CommandButton (Control).
That?s the problem when i click on that button, i have to make some code so the button knows whats in that combo box and go to lets say Sheet3 and pick out this date 1.4.2006 (which can be few rows) and copy them to a new sheet, let?s say Sheet4. (So i need some kind of loop also).
Another thing which can be problem is that the column looks like this: ,,1.4.2006 11:49:40", but the time dosen?t matter, only the date.
Can somebody help my with this?:help
Regards,
Gussi
I?m having problem with date & time.
I Have ? Combo box (Forms) which i?ve set up so I can choose date back in time from Data which i have in one Sheet.
Dim index As Integer
index = Cells(2,7)
Dim ticker As String
ticker = Cells(index + 1, 6)
In the combo box. I right clicked and picked the series of my dates and set the other thing as the index. Then i can click on the side of the combo box and choose these dates.
So when I?ve chosen the date, let?s say 1.4.2006 then i have to click on a CommandButton (Control).
That?s the problem when i click on that button, i have to make some code so the button knows whats in that combo box and go to lets say Sheet3 and pick out this date 1.4.2006 (which can be few rows) and copy them to a new sheet, let?s say Sheet4. (So i need some kind of loop also).
Another thing which can be problem is that the column looks like this: ,,1.4.2006 11:49:40", but the time dosen?t matter, only the date.
Can somebody help my with this?:help
Regards,
Gussi