userfrom consist of 3 list box to insert attendance for employee

Please kindly find attached file want to make the code
i have userform to add attendance to attendance sheet starting in row 8 as in sheet attached
list of operator every time will be appear in list box number one then i select the employee absent list box 2 and transfer to absent list
and if i transfer the data incorrect i can transfer it again to listbox 1
then from list box 1 also i select the employee want to transfer to list box 3 and also can return it again
finally want the sheet come as in my attached file


this is my design
if some one have another simple design can do this in simple way with userform can advice me

Dear gmr4evr1
First I would like to thank you for quick reply
Tomorrow because I didn't have any access to my computer now will check and let you know if it work for me or not
Best regards

Because I replayed you from my phone

And what about add attendance button code

Made listbox1 multi select, so first select all items

Please Login or Register  to view this content.

Kind regards
Leo

Dear Leo
i found your code work good but i note two problem
first when i press add attendance to sheet its add data even the textbox for date is empty and when i press again its the same data to next column and soon without look to corresponding date
also when i press button transfer from is also work good from present list to absent but if i want to return it again its remove the data from list box without return it

Originally Posted by LeoTaxi

Made listbox1 multi select, so first select all items

Please Login or Register  to view this content.

Kind regards
Leo

Dear gmr4evr1
many thanks for your effort
i test your file an also note that only can transfer one by one and not can retrun data again

Originally Posted by gmr4evr1

Something like this...
Attachment 528375

I haven't coded the Add attendance button yet

please see my attached file with new userform design

please see this new attached file

With modifications, all listboxes are multi select
you can move between listboxes as match if you want

Please Login or Register  to view this content.

Kind regards
Leo

thank you dear LeoTaxi
its work now but only have note when i apply this with my original data its not allow to multiple selection
also i note in your file if i enter result for the same date two times with different data its accept ( can change the code that show message that this date is inserted before do you wt to proceed )

thank you dear LeoTaxi
also if i need to insert date when i press insert attendance instead of date already present in row 8
i mean also want to insert date with attendance in list box

Modification in CommandButton2

if date is not found, date and data is coming in first free column in row 8
if date is found but there is already data, user can choose to cancel or replace old data by new

for the multi select you have to change each listbox properties (see picture)

Please Login or Register  to view this content.

In this with extra option to choose new date

Please Login or Register  to view this content.

Kind regards
Leo