how can I trap the change event (Tab Press key) of these controls
 

I have a User form with a frame. In that frame, I add TextBox controls during
run time using VBA of Excel 2000.

how can I trap the change event ( specially Tab Press key) of these controls
(ie TextBox) which were added at runtime in Excel 2000?

how can I trap the change event (Tab Press key) of these controls
 

you would have to add code to the form class at runtime as well. It's easier
to add them at design time and hide them until needed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Padam" wrote in message
...
I have a User form with a frame. In that frame, I add TextBox controls
during
run time using VBA of Excel 2000.

how can I trap the change event ( specially Tab Press key) of these
controls
(ie TextBox) which were added at runtime in Excel 2000?