Hi, I have a sheet called Timeliste,
<tbody>
</tbody>
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![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Consultan | Date | Customer | Activity | Comments | Start time | End time | Total time | Customer ref | Changing order |
Jo Doe | 03.01.2014 | Test Customer | Test | Test | 11:00 | 12:00 | 02:00 | 34 | |
Jo Doe | 06.01.2014 | Test2 Customer | Test2 | Test | 12:30 | 52 | 9878 |
<tbody>
</tbody>
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