Rustywinger Posted October 31, 2007 Report Posted October 31, 2007 This is driving me nuts. If I am in Excel and hit CNTL-A via keyboard, everything gets selected. If I put that into a "Text Type" macro, only a single cell gets selected. I tried a "record macro" just to see if recording the CNTL-A made a difference, but no. Still wouldn't select within the workbook. ??... I mean... ?!?!?! Also, CNTL-N is not creating a new file in Excel when used in a macro so this *seems* like a common issue, but I don't see any instances of this problem in the knowledge base (or am guilty of not looking hard enough). So if anyone can shed light no this, please send a light bulb my way. Quote
kevin Posted October 31, 2007 Report Posted October 31, 2007 Microsoft Office applications seem to be more sensitive than other applications to timing issues. I would try this: Text Type: <CTRLD> Delay 0.25 Seconds Text Type: <CTRLU> If it works you should try reducing the amount of time to delay. Quote
blopib Posted November 1, 2007 Report Posted November 1, 2007 We have set the delay time for Text Type in Options/Preference/Delays -Use Text Type delay to 10000 microseconds. It solved our problems with text type in some forms. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.