+ Reply to Thread
Results 1 to 3 of 3

Run macro when you change position on row

  1. #1
    Registered User
    Join Date
    06-04-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Run macro when you change position on row

    Hello,

    I want to run macro every time when I change row by arrows down or up.

    Can someone help?

    Thank you!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,941

    Re: Run macro when you change position on row

    Based upon what you have provided, I believe you are looking for an event handler. Specifically, SelectionChange event. Look at this link

    http://msdn.microsoft.com/en-us/libr...ffice.14).aspx
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-04-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Run macro when you change position on row

    Hello...no exactly...

    when I go down or up then I need to run one macro.

    This macro... copy value from activerow and specific column to AD3 than find this copied value in other 15 columns and copy values from found column under value AD3. And I want..when I change row by arrow than macro run...and to his work...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to change the position within a cell
    By sekharks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2014, 06:56 AM
  2. [SOLVED] Calculating position change
    By Crackerdaq in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 06:22 AM
  3. how to change position of data.
    By kghisla in forum Excel General
    Replies: 9
    Last Post: 09-14-2010, 08:42 AM
  4. Macro to create worksheet, change it's position, and paste date into it.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-19-2009, 02:47 PM
  5. How to change the position of a comment box
    By Frederic in forum Excel General
    Replies: 2
    Last Post: 05-26-2005, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1