Hi,

i have a userform which is the front end to the sheet and have written the code so taht on the clicking of a button the data is written to another workbook.
I want the form to display a message on the hour every hour to prompt the user to enter soem information.
I also need for every 1 minute past the hour to run a subroutine that calls for the data from another file.

I have tried searching and found the application.ontime code.
on the userform initialize sub i have placed 24 liens of code.
1 for each hour starting at 00:00
Application.OnTime TimeValue("00:00:00"), MsgBox("Ima Count Now Due")

when i run this it runs everyline straight away and not on the hour every hour.

How can i do this? has anyone done this before? what approach do i need to take or am i missign somethign really drastic?

Any help is greatly appreciated

Regards,

Alan