Hi, I have a sheet called Timeliste,
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Consultan
[/TD]
[TD]Date
[/TD]
[TD]Customer
[/TD]
[TD]Activity
[/TD]
[TD]Comments
[/TD]
[TD]Start time
[/TD]
[TD]End time
[/TD]
[TD]Total time
[/TD]
[TD]Customer ref
[/TD]
[TD]Changing order
[/TD]
[/TR]
[TR]
[TD]Jo Doe
[/TD]
[TD]03.01.2014
[/TD]
[TD]Test Customer
[/TD]
[TD]Test
[/TD]
[TD]Test
[/TD]
[TD]11:00
[/TD]
[TD]12:00
[/TD]
[TD]02:00
[/TD]
[TD]34
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jo Doe
[/TD]
[TD]06.01.2014
[/TD]
[TD]Test2 Customer
[/TD]
[TD]Test2
[/TD]
[TD]Test
[/TD]
[TD]12:30
[/TD]
[TD][/TD]
[TD][/TD]
[TD]52
[/TD]
[TD]9878
[/TD]
[/TR]
</tbody>[/TABLE]
What I like to do is show this information on a listbox in a userform but only the information that not have End time yet.
So when a employee see witch line that not have a End time yet, I like to get the function that the employee can click on that line in the listbox and then get
a New form up so they can put in a End time.
Hope somone can help me out here.
I'am not so good in Excel so please give me a exsample
Roy
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Consultan
[/TD]
[TD]Date
[/TD]
[TD]Customer
[/TD]
[TD]Activity
[/TD]
[TD]Comments
[/TD]
[TD]Start time
[/TD]
[TD]End time
[/TD]
[TD]Total time
[/TD]
[TD]Customer ref
[/TD]
[TD]Changing order
[/TD]
[/TR]
[TR]
[TD]Jo Doe
[/TD]
[TD]03.01.2014
[/TD]
[TD]Test Customer
[/TD]
[TD]Test
[/TD]
[TD]Test
[/TD]
[TD]11:00
[/TD]
[TD]12:00
[/TD]
[TD]02:00
[/TD]
[TD]34
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jo Doe
[/TD]
[TD]06.01.2014
[/TD]
[TD]Test2 Customer
[/TD]
[TD]Test2
[/TD]
[TD]Test
[/TD]
[TD]12:30
[/TD]
[TD][/TD]
[TD][/TD]
[TD]52
[/TD]
[TD]9878
[/TD]
[/TR]
</tbody>[/TABLE]
What I like to do is show this information on a listbox in a userform but only the information that not have End time yet.
So when a employee see witch line that not have a End time yet, I like to get the function that the employee can click on that line in the listbox and then get
a New form up so they can put in a End time.
Hope somone can help me out here.
I'am not so good in Excel so please give me a exsample
Roy