Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell value change event | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel | |||
Worksheet Change Event | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Change of Row event | Excel Discussion (Misc queries) |