<div>
I thought of the timer idea, but there isn't a timer in the VBA toolbox. How do you use a timer in a VBA App?
</div>


I thought of the timer idea, but there isn't a timer in the VBA toolbox. How do you use a timer in a VBA App?

<div>
Check this link to use timer API to replicate timer functionality in VBA.<br />
<br />
<a href="http://www.developerfusion.com/show/1090/" rel="ugc">http://www.developerfusion.com/show/1090/</a><br />
<br />
Have a nice day.
</div>


Check this link to use timer API to replicate timer functionality in VBA.

http://www.developerfusion.com/show/1090/ [http://www.developerfusion.com/show/1090/]

Have a nice day.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Answered mazfar<br />
&nbsp;<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
leonstryker<br />
EE Cleanup Volunteer 
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered mazfar
 
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

leonstryker
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
I have an VBA application that talks to a serial device, which acts as a converter and talks to another device. I would like a way for the application to timeout if it doesn't recieve a response in a certain period of time.<br />
<br />
The trouble with the timeouts built in to mscomm (that I know of) is that they will only detect if the serial device is there when the app is transmitting, but I need to know if the third device is not responding.<br />
<br />
Thanks and sorry if I wasn't clear enough.
</div>
</div>


Hi.

I have an VBA application that talks to a serial device, which acts as a converter and talks to another device. I would like a way for the application to timeout if it doesn't recieve a response in a certain period of time.

The trouble with the timeouts built in to mscomm (that I know of) is that they will only detect if the serial device is there when the app is transmitting, but I need to know if the third device is not responding.

Thanks and sorry if I wasn't clear enough.

MSComm Timeout

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.