I have a VBA form with the date and time displayed. It will refresh each time a user enters a value in the combo box on the form. I would like to have it refresh every minute or two so that the user will see a relatively accurate date and time.
I'll walk you through creating a simple example and provide a download that is the result of the instructions given. Between the two, you should not have any problems adapting this method to your current userform.
Open a new workbook, add a userform("UserForm1"), add a Label and change its name to "DateAndTime". Add a standard module. Paste the first code listing into the userform, the second into the standard module.