From: Cor Ligthert[MVP] on
Armin,

In fact, very much my style, I had not expected this from you.

But a very good analogy.

Cor

..
>
> Whenever the sun shines, your solar cells work and the generated
> power switches a lever. If it's dark, you have to switch the lever
> manually instead of trying to make the sun shine.

From: Armin Zingler on
Am 25.04.2010 11:20, schrieb Cor Ligthert[MVP]:
> Armin,
>
> In fact, very much my style, I had not expected this from you.
>
> But a very good analogy.
>
> Cor
>
> ..
>>
>> Whenever the sun shines, your solar cells work and the generated
>> power switches a lever. If it's dark, you have to switch the lever
>> manually instead of trying to make the sun shine.
>

:-) Well, but you're putting a torch on the solar cells to "produce" energy,
whereas I'm pressing the lever myself. So we don't agree.

In other words: Never call an event handler manually. No event occured.
Instead, start the same thing in the event handler and also in the code
where you want to start it.

And in code words: (also for Mr. Eggs)

sub MyRowChangeMethod(sender, args)

DoIt 'Here's where you want to do it

End Sub


sub YetAnotherMethod

yadayada
DoIt 'and here you wanna do it also
yadayada

end sub


sub DoIt

debug.print "about to do it..."
sleep a long time
debug.print "dunnit!"

end sub


--
Armin