Jump to content
Macro Express Forums

Cursor Movement


ConradPlutt
 Share

Recommended Posts

I use a very simple code where I want to type a variable

into a cell in a Excel spreadsheet.

 

<TEXTTYPE:%T7%>

 

It works fine except that after typing the cursor moves down to the

cell below.

 

If I past from the clipboard the cursor remains in the cell.

 

 

The best would be if the cursor remains in the cell, second best if

it moved to the right.

 

Is there a way to control the behavior of the cursor after typing?

 

I´m a newbi to this program and have only explored a fraction of its

possibilities but this behavior of the cursor spoils most of the projects

I intended to use it to.

 

I would be most grateful for any help

Link to comment
Share on other sites

The movement of the cursor to the next cell is controlled by Excel, not Macro Express. Macro Express will automate whatever you can do manually. To see this, try typing into the cell. Excel will move the cursor to the next cell. Now run your macro that types into a cell. The actions should be the same.

 

You can easily return the cursor to the original cell by adding Arrow Up to your Text Type command.

Text Type: %T7%<ENTER><ARROW UP>

You may need the ENTER key in between.

Link to comment
Share on other sites

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...
 Share

×
×
  • Create New...