Rework _KeyPress code into a sub routine or class that can be called by multiple events

[jonharrell]

How could one repackage this sub routine that triggers on the event _KeyPress and handles the field validation and returns the value back to the sub that called it or interacts directly with the field as Me.value.

the routine is mentioned in the following thread:

http://www.excelforum.com/excel-prog...-text-box.html

Please Login or Register  to view this content.

[AlphaFrog]

You want to use the same code for multiple textboxes?

[jonharrell]

Yes, basically be able to pass the reference of a field on to the routine. Just not sure how to do that with VBA.

[AlphaFrog]

Yes, basically be able to pass the reference of a field on to the routine. Just not sure how to do that with VBA.

Please Login or Register  to view this content.