Hi all,

I have a problem when trying to use a UserForm alongside a Macro that updates every n seconds.

My Macro uses the Application.OnTime function to run every 3 seconds. Whilst it is doing this I want to have a UserForm open for me to input values that are used elsewhere within my program. Trouble is whenever the UserForm is open my Macro stops running in the background until I close the userForm, and then it starts running again. I want to have the form constantly open as I'll be inputting data into the program as it runs. Is there a simple way to do this?

Thanks,

W