Questions tagged [ontime]
54 questions
2
votes
1 answer
application.ontime not cancelling or running in background
I'm using the Application.Ontime command to automatically close a spreadsheet after a period of inactivity (10 minutes).
The following code seems to work in general, however, it appears that if you manually close the sheet yourself, the workbook…
Bodz38
- 21
- 3
2
votes
1 answer
Excel VBA: How to use Application.ontime to call a click event?
I'd like to use the Application.ontime method to call a button_click event on my Excel form.
when i use this code I can call a sub located in my Module1:
Application.OnTime Now + TimeValue("00:00:15"), "test"
However if I use this code it doesn't…
sims
- 145
- 2
- 11
2
votes
3 answers
How refresh selection with OnTime? Error: Cannot run the macro
The cell refreshes when I run the macro the first time
Sub RefreshAction()
Range("b7").Select
Application.Run "RefreshCurrentSelection"
Application.OnTime (Now() + TimeValue("00:00:05")), "thisworkbook.Action"
End Sub
I get an error…
fdt6243
- 45
- 1
- 5
2
votes
1 answer
Excel VBA: Application.OnTime Not Executing Properly
I am trying to run a certain macro in very short intervals, such as every second, from a certain point in time until a certain end point in time. This means I need a starting point and a cutoff point. I cannot use the Workbook_Open() Event, since I…
Yaron
- 23
- 1
- 3
2
votes
1 answer
Obtaining Authorization token
I'm trying to obtain a authorization token for OnTime OnDemand API using asp.net mvc. below are my simple action methods to obtain the token.
public ActionResult Index()
{
string eURL =…
chamara
- 12,649
- 32
- 134
- 210
2
votes
1 answer
VBA: Reliable timing with Application.OnTime?
I need to run a large procedure (RunLargeSub) every second, and this procedure takes about 0.5s to complete. I'm currently using Application.OnTime, but won't this result in RunLargeSub being called every ~1.5s ? Is it possible to fix this to…
Michael Mathews
- 21
- 1
- 6
1
vote
2 answers
Add two 'release' fields on one form (Axosoft onTime tracker)
I'm using Axosoft Ontime for bug tracking, and have configured several 'release' items under my project.
'Default' (ie. bug) list has a field named 'Release' that displays on forms as a dropbox of all available 'release' items. Fine. I use it as a…
PPC
- 1,734
- 1
- 21
- 41
1
vote
1 answer
How to Fire OnTime Event by a Workbook.Close Statement?
It appears that if the OnTime event is registered by a programmatic MyBook.Close statement, then OnTime never runs.
This code works fine:
Sub TestOnTime()
Application.OnTime Now + TimeValue("00:00:05"), "MySub"
End Sub
Sub MySub()
…
johny why
- 2,047
- 7
- 27
- 52
1
vote
0 answers
On Time and countdown (seconds) event handler for radio button
I must create an application which basically has to open a blinking window, at a future moment set by the user or in the second case, with a delay of 1-5 seconds, decided by the user. Below is the code I tried to write, but I'm stuck on creating the…
Cristian73
- 11
- 1
1
vote
3 answers
How to set ontime user input text from EditView to TextView without clicking the button
I was doing practice and I am stuck at one point that I want to set ontime user input text from EditText to TextView but I don't know how can I do this so I search it here and I found this How to get EditText value to TextView at the time of typing…
Mohammad zeeshan
- 21
- 5
1
vote
1 answer
VBA Stop OnTime Function
Could someone please help me how to stop the OnTime Function? It doesnt work the way I tried it.
Option Explicit
Dim iTimerSet As Double
Public Sub FXKurs_Wahl()
iTimerSet = Now + TimeValue("00:05:00")
Application.OnTime iTimerSet,…
Maths student G
- 15
- 5
1
vote
0 answers
VBA charts not refreshing with refresh.all or if I loop through the charts
Hello I am trying to write a script that will call a function to refresh charts every 30 seconds. The first function provided works by simply telling the machine to run my other function "RefreshCharts" after 30 seconds. The problem I am having in…
Miguel Sanchez
- 13
- 4
1
vote
1 answer
Button to stop subs with OnTime Macro doesn't stop
I have a button assigned to the StopRecordingData sub to cancel both subs and it doesn't. The schedule False doesn't seem to cancel the scheduled subs in que.
Dim NextTime As Double
Sub RecordData()
Dim Interval As Double
Dim cel As Range,…
mjac
- 125
- 11
1
vote
3 answers
Workbook, Save, Close, Re-Open (w/ TimeValue),Repeat
The macro runs with a button assigned to "CloseMe". It used to run for my needs but doesn't anymore (as I tried using this code in another workbook without success). Now it saves, closes, waits 10sec to reopen, but then closes right away.
Sub…
mjac
- 125
- 11
1
vote
1 answer
Excel VBA OnTime Macro running multiple times
I have a simple code that will copy the current value of my stock portfolio and paste it into a table. I recently tried to add in a timer so that it did this automatically every hour. It works, however, it pastes the value four or five times into…
mclapham
- 43
- 4