Creating an Event Log on a userform

Hi guys, so with my program there are 3 userforms available for the User to enter in a Batch Number value to a text box, e.g: EntryForm1, EntryForm2, EntryForm3. And 1 userform called HomeForm where I would like to create an Event Log screen or textbox that will show the recent Batch Numbers that have been entered via any of the EntryForms.

For example if Batch Number "0E1234" was entered into textbox on EntryForm1 and the Enter button is clicked, then on the top of the list on the Events Log it will appear - "Batch number 0E1234 has moved to the Production Office."
Then for example if Batch Number "1E9876" was entered into textbox on EntryForm2 and the Enter button is clicked, then on the top of the list on the Events Log it will appear - "Batch number 1E9876 has moved to the QA Office."
And then for example if Batch Number "5E5555" was entered into textbox on EntryForm3 and the Enter button is clicked, then on the top of the list on the Events Log it will appear - "Batch number 5E5555 has moved to the QP Office."

The events log only has to show approximately 10 of the most recent movements on the program.

If any one out there has any ideas if this type of function is possible to achieve in VBA, many many thanks in advance.

Cool thanks very much, I have attached my file. If you have any questions about it, don't hesitate to ask.

Leith, Yes to expand more on what will happen- In any of the Entry userforms, once the user has filled in the text boxes and clicks the Assign Batch Record button, the Batch Record Number will be saved in an appropriate spreadsheet in the workbook, also upon clicking this button the Event Log will be updated on the Homepage, and will be saved there until 10 new events occur of a user clicking the Assign Batch Record button on any of the 4 Entry userforms.

So yes they do need to be retained on the HomePage userform until it is moved down the list of most recent event and disappears from the screen.
And they will already be retained in spreadsheets using code in the Assign Batch Record button.

Hi mehmetcik, thank you very much, your code works perfectly. Do you know of any method of saving that information on the userform? So when the user goes off the screen and back to it again it will still be there, and if the user adds more batch numbers they will be just updated.

Mehmetcik, I got your code to work to my liking, thank you very much for that much appreciated.

I have one more question about how to get a Button on a spreadsheet to click and run its code, after the user clicks a button on the userform?