Jump to content
Macro Express Forums

Recommended Posts

Posted

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.

Posted

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.

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...