Search the web
Sign In
New User? Sign Up
mbtsdk · MB Trading ~ SDK for the MBT Navigator
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
OnTime method with ExcelSDK   Message List  
Reply | Forward Message #2515 of 7725 |
Re: [mbtsdk] OnTime method with ExcelSDK

Timers interfere with event callbacks. Instead of executing code in the timer procedure itself, have the timer call an external procedure. Take a look at post 2434, below. In particular, scroll down and get to the meat of the topic, which says:
------------------------------------------------
 ...
 SetText(s) ` this works
 Me.TextBox2.Text = s 'this doesn't
End Sub
 
Private Sub SetText(ByVal [text] As String)
 ...
------------------------------------------------


soutmatt <soutmatt@...> wrote:
I'm trying to add a macro to the ExcelSDK that uses the OnTime method.
I've tested it and it works fine in a separate workbook but when added
to the ExceSDK project it does nothing. Any ideas?






Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mbtsdk/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/mbtsdk/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:mbtsdk-digest@yahoogroups.com
mailto:mbtsdk-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
mbtsdk-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/






Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

Wed Oct 11, 2006 10:52 am

mbtsdk
Online Now Online Now
Send Email Send Email

Forward
Message #2515 of 7725 |
Expand Messages Author Sort by Date

I'm trying to add a macro to the ExcelSDK that uses the OnTime method. I've tested it and it works fine in a separate workbook but when added to the ExceSDK...
soutmatt
Offline Send Email
Oct 11, 2006
3:36 am

... ... SetText(s) ` this works Me.TextBox2.Text = s 'this doesn't End Sub Private Sub SetText(ByVal [text] As String) ... ...
Phil Huether
mbtsdk
Online Now Send Email
Oct 11, 2006
10:54 am

Thanks for that but the problem was just my bad coding which I've sorted now. The OnTime method in Excel VBA is different from VB timers. You need to create a...
soutmatt
Offline Send Email
Oct 11, 2006
9:59 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help