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. Thanks N.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. > Thanks > N.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.
on_cursor_movement-3.xlsm
Description: Binary data
