Of the top of my head I can't think of any difference in behaviour with
Textbox events between XL 2002/2007. Why not post your code, also say in
which version the original workbook was created (if not new workbooks in
each respective version).

Regards,
Peter T

"Boog" wrote in message
...
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