Your attachment didn't contain any macros. So, ctrl-m didn't have any affect.
I also noticed that you have not ASKED for anything. What you've done is provided a "reference". which consists of an excel file with one row and column highlighted in blue. You then instructed us to open your reference, enable macros, and hit ctrl-m and click to see your "requirement". You then once again stated that you desire to have "this task" completed by mouse or keyboard movement. Evidently, this is your way of saying that you don't have any idea what I meant by a SelectionChange event macro, and you'd like someone to make one for you. -------------------------------- Based on the limited information, I suspect that you want to highlight the row/column of the currently selected. To this end, I recorded a macro in which I cleared cell highlighting for all cells. Then, highlighted the row/column of the currently active cell. I "cleaned up" this recorded macro to make it run more efficiently. I then created the sheet selectionchange event, and had it execute the previously created macro. Attached you will find a file in which I have done these things. You'll find the "hightlight" macro called Highlight_Row_Col in the Mod_Highlight module. the Event macro is in the Sheet1 module and is called Private Sub Worksheet_SelectionChange(ByVal Target As Range) Please note: Event macros must be placed in the worksheet module and only apply to the specific worksheet. That is: If you add a second sheet, this event macro will not execute for changes in that sheet. If you want an event macro to run for ALL worksheets, a SIMILAR event macro (not called the same thing) can be created in the "Thisworkbook" module. let me know if you have any questions. (and what they are) Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Sundarvelan N <nsund...@gmail.com> To: excel-macros@googlegroups.com Sent: Wed, October 17, 2012 8:13:09 AM Subject: Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move Please find the attached file for your reference Opne the file enable the macro and press ctrl+m and click any where in the excel you will find my requirement. I need this task should be completed by mouse/keyboard move. ThanksN.Sundarvelan 9600160150 On Wed, Oct 17, 2012 at 5:26 PM, Paul Schreiner <schreiner_p...@att.net> wrote: You explanation is somewhat vague.. >By breaking it down into individual definitions: > >"Repeating the macro" implies that you have a macro in mind.. good start. > >"cursor" is a general term referred to the "type-in bar", usually a vertical >bar >(|) or underscore (_). > >"cursor move" would then be movement of that "type-in bar". >However, that would be a problem. >By strict definition, the "type-in bar" doesn't appear unless you are editing >the contents of a cell. Either by double-clicking and entering the cell, or >clicking inside the content box near the address bar. >Then, the implication is that if you use the left-arrow and move one character >to the left, the macro would run.. if you insert a character, the macro would >run. >This isn't possible... > >Technically, when you select a cell, there is no "cursor" because you have >not begun to edit the contents. > >However, if instead of "cursor move" you mean when a cell is SELECTED. >Then there are possibilities. > >You can create a Worksheet_SelectionChange event macro >that would execute each time a cell is selected >(unless you select the cell which is currently selected > in which case the selected cell hasn't changed) > >in the Event macro, you would then call your previously defined macro. > >let me know if you need help creating a selectionChange event macro. > >Paul >----------------------------------------- >“Do all the good you can, >By all the means you can, >In all the ways you can, >In all the places you can, >At all the times you can, >To all the people you can, >As long as ever you can.” - John Wesley >----------------------------------------- > > > > > ________________________________ From: Sundarvelan N <nsund...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wed, October 17, 2012 2:10:40 AM >Subject: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move > > > >Dear Gurus, > >Please help me in repeating the macro for each cursor move. > >ThanksN.Sundarvelan >9600160150 >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ members already BANNED for violation) > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. > >2) Don't post a question in the thread of another member. > >3) Don't post questions regarding breaking or bypassing any security measure. > >4) Acknowledge the responses you receive, good or bad. > >5) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > > >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ members already BANNED for violation) > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. > >2) Don't post a question in the thread of another member. > >3) Don't post questions regarding breaking or bypassing any security measure. > >4) Acknowledge the responses you receive, good or bad. > >5) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
on_cursor_movement-3.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12