Pick time from cell

  • Thread starter Thread starter Kash
  • Start date Start date
K

Kash

I have the below code.. can make the time pick from a cell?
Sheets("Set").Range("A8")

Application.OnTime TimeValue("22:50:00"), "cls"
 
Try it this way...

Application.OnTime TimeValue(Sheets("Set").Range("A8")), "cls"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Run-time error '1004' General ODBC Error 1
Simple Variable to someone 5
Run time error 2
Copy and paste range ontime 2
Automatic increment of onTime 4
time elapse on userform label caption 3
Timer Event 2
Stop timer. 5

Back
Top