B
Boog
Hello Y'all,
Using Vista HP SP1 and Excel 2007 SP2.
I created a workbook using XP Home / Excel 2002. I am updating the workbook
on a Vista system for use with Excel 2007 and saved the workbook as an
..xlsm. The workbook update is to simply make any code changes from Excel
2002 to Excel 2007 and to take advantage of changes in Excel 2007 over Excel
2002 such as a cells gradient color fill, 3D features, etc.
I am starting this thread for any explanation(s) of the following behavior
but I have since found two solutions.
The problem I had was that an ActiveX textbox KeyUp event was not firing for
any alphanumeric characters; only for Ctrl, Shift and Alt. The KeyDown and
KeyPress events worked fine. I have another workbook that I have made
similar changes to and the textbox KeyUp events work fine.
Initially, I deleted the textboxes and recreated them without success.
The first solution I found was to use the textbox KeyPress event in
combination with the Change event.
Then, I copied a textbox from a functioning workbook to the problem workbook
and the KeyUp event worked problem free for the new textbox. The only
difference between the textboxes was that the troubled textboxes had linked
cells and the working ones did not. I eliminated the linked cell from the
textboxes and the KeyUp events started functioning normally. Strangely, I
opened a blank workbook, added a textbox with a linked cell and the KeyUp
event worked fine ???
I searched this NG and spent time Googling and Binging to see if this was a
documented problem but I had no joy.
There is obviously something corrupt in this particular workbook. It
otherwise functions as desired.
I don't have any specific question. I am mentioning this in case others
have encountered this and I am (slightly) curious regarding any possible
explanations. I put my money on stuff happens <LOL>.
Thanks,
Boog
Using Vista HP SP1 and Excel 2007 SP2.
I created a workbook using XP Home / Excel 2002. I am updating the workbook
on a Vista system for use with Excel 2007 and saved the workbook as an
..xlsm. The workbook update is to simply make any code changes from Excel
2002 to Excel 2007 and to take advantage of changes in Excel 2007 over Excel
2002 such as a cells gradient color fill, 3D features, etc.
I am starting this thread for any explanation(s) of the following behavior
but I have since found two solutions.
The problem I had was that an ActiveX textbox KeyUp event was not firing for
any alphanumeric characters; only for Ctrl, Shift and Alt. The KeyDown and
KeyPress events worked fine. I have another workbook that I have made
similar changes to and the textbox KeyUp events work fine.
Initially, I deleted the textboxes and recreated them without success.
The first solution I found was to use the textbox KeyPress event in
combination with the Change event.
Then, I copied a textbox from a functioning workbook to the problem workbook
and the KeyUp event worked problem free for the new textbox. The only
difference between the textboxes was that the troubled textboxes had linked
cells and the working ones did not. I eliminated the linked cell from the
textboxes and the KeyUp events started functioning normally. Strangely, I
opened a blank workbook, added a textbox with a linked cell and the KeyUp
event worked fine ???
I searched this NG and spent time Googling and Binging to see if this was a
documented problem but I had no joy.
There is obviously something corrupt in this particular workbook. It
otherwise functions as desired.
I don't have any specific question. I am mentioning this in case others
have encountered this and I am (slightly) curious regarding any possible
explanations. I put my money on stuff happens <LOL>.
Thanks,
Boog