Form Events VBA 6.5

[niels_r]

Hallo,

ich versuche vergeblich in VBA 6.5 mehreren TextFields in einer Form den selben Event zuzuweisen. Gibt es eine Möglickeit die TextField-Elemente mit einer Schleife zu durchlaufen und einen Handler hinzuzufügen?

Vielen Dank,
Niels

 

[Andrew Poulsom]

Welcome to the Board.

You will need a Class Module:

http://www.mrexcel.com/forum/showthread.php?t=65901

I hope you can read English.

 

[niels_r]

Thanks a lot! That is exactly what I was looking for.

 

[niels_r]

I Have one more question.

The solution works excellent with change and click events. Is there also a possibility to fire an event on exit / lostfocus of a textbox?

Regards,

Niels

 

[Andrew Poulsom]

Sorry no. The Exit event is one of those that is not exposedin a Class module, as you may have seen from its absence in the dropdown of available events. Some events are only exposed at the container level (UserForm or Worksheet).

 

[Greg Truby]

To add to what Andrew said, Colo has a way of doing this by raising custom events. However, because of what Andrew just indicated, i.e. these events are not exposed in the object model, Colo ends up running a continual loop "scanning" for the opportunity to raise the custom event. It's been a couple of years since I tried Colo's code - I haven't run it in a multi-processor environment, so I don't know if it would pin the needle on both CPU's or thread to just one.

http://www.mrexcel.com/forum/showthread.php?t=66773

Howdy, Andrew. Been well, I trust.