Visitor log macro

Hi, I'm trying to make an excel based visitor log book whereby visitors would scan their identification card when they come in and the details would be logged. There are some questions which I hope can be answered.

1) How do I code it such that when an ID that exist in the lookup tab is scanned in textbox1, the name of the ID holder would appear in textbox2?
2) If an ID and name that does not exist in the lookup tab, that particular ID and name would be added to the lookup list after signing in for future visits?
3) The code I have now logs a time in in column D, how do I code it such that when a person who has signed it scans the ID again, it will log that person out and generate a date/time out in column E?

Have attached the workbook for reference

Hi meabrams, thanks for your help!! it works the way I hope it would. Would you be able to help with question 2? I keyed in a number that does not exist in the lookup tab, and after signing in, the data is not captured in the lookup tab

Ah Thank you so much. Can you please help me with 1 last question? I have a status textbox in the form. What I hope to have inside is, for example, Ben is already signed in and when you scan his ID number again, the status textbox would have the message "Ben was signed in on/at (column D value)". This is so that users who administers the signing in process knows whether this person is signing in or out.

Hi meabrams, sorry for being unable to convey my intentions. The status textbox is to show the user if a visitor is signing in or signing out. If signing out, then the status box would display when did the visitor signed in. The purpose is to know which visitors coming and which are going.

Thank you bakerman for the contribution

You 2 have been a great help to me