hi all,
i want to refresh my worksheet after 5 minutes interval even if there is no any change in worksheet.i have a small tracker which allow users to store and retrive data from Ms-Access. i want a Message popup after every five minute
Like: -
Application.OnTime Now + TimeValue("00:00:05"), "my_Procedure"
how to call "my_Procedure" after 5 minues interval ??
thanks in advance
i want to refresh my worksheet after 5 minutes interval even if there is no any change in worksheet.i have a small tracker which allow users to store and retrive data from Ms-Access. i want a Message popup after every five minute
Like: -
Application.OnTime Now + TimeValue("00:00:05"), "my_Procedure"
how to call "my_Procedure" after 5 minues interval ??
thanks in advance