P
pinkfloydfan
Hi there
I have a form with two TextBoxes each of which has an _Enter event.
In each case the _Enter event binds to the same Excel
SheetSelectionChange event.
What I want to know is: within the SheetSelectionChange event how can
I determine which _Enter event fired it and therefore which TextBox I
should be manipulating by this code?
I have tried working off the Focused property of the TextBox but
unfortunately as you shift to Excel this changes.
Thanks for your advice
I have a form with two TextBoxes each of which has an _Enter event.
In each case the _Enter event binds to the same Excel
SheetSelectionChange event.
What I want to know is: within the SheetSelectionChange event how can
I determine which _Enter event fired it and therefore which TextBox I
should be manipulating by this code?
I have tried working off the Focused property of the TextBox but
unfortunately as you shift to Excel this changes.
Thanks for your advice