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
------------------------------------------------
...
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.