Rustywinger Posted October 31, 2007 Report Share 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 Link to comment Share on other sites More sharing options...
kevin Posted October 31, 2007 Report Share 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 Link to comment Share on other sites More sharing options...
blopib Posted November 1, 2007 Report Share 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 Link to comment Share on other sites More sharing options...
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.