EditDate = Now Application.OnTime Now + TimeValue(Sheets("main").Range("A7").Value), "TestForUpdates"
I cannot seem to get the correct method for the above to work, instead of hard coding the set time in hh:mm:ss.
Am i missing something obvious ?
What do i set the cell format to hh:mm:ss or number etc ?
Untested.
Try changing .Value to .Text
Last edited by WasWodge; 04-09-2013 at 03:39 AM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks