Form_Timer

[aw23]

I'd like to have 2 different events running on 2 different timers. Is this possible?

Thanks

 

[ZmrAbdulla]

Can be the second one with a hidden(loaded) form's timer

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

I don't quite understand. As I understand, in VB, you put a timer control on your form and I'm assuming you can put as many as you want. However in VBA, it is an event, form_timer. Is this accurate? So how can you have more than one? ANd how can it be hidden?
Thanks

 

[PHV]

If one TimerInterval is a multiple of the other you may share the Timer between 2 events with some static counters.
Otherwise, as Zameer stated, play with an hidden form having its own Timer event.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZmrAbdulla]

You can temporarily store the timer time into two textboxes with multiplication of your own choice then act as per the value of the textboxes.
You may have to do some CIRCUS to increment the value+calculation result
something like this..

Private Sub Form_Timer()
	Me.Text2.Value = Me.Text2.Value + Me.Text2.Value * 2
	Me.Text0.Value = Me.Text0 * 3
End Sub

HTH

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[ZmrAbdulla]

aw23,
Did you find a solution for this? I can see your posts. If you solved or done any different solution please let us know, so that others learn something from that
Regards

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

I have not yet tackled this. I will let you know as soon as I do. Thanks

 

[ZmrAbdulla]

OK fine..

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me