 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Moving from one place to another depending on value in certain cell
Hi to everybody, In a worksheet I need to move between certain location (cells); these cells are: A8, A68, A128, A188, A248, A308, A368, A428, A488, A548, A608, A668 What I want is: If I put 1 in cell B1 and press ENTER the cursor move to cell A8 (A8 will be the active cell), If I put 3 in cell B1 and press Enter to go cell A128 and so on with other cells from 1 to 12. Can any one help please. Several methods to do this. 1. Unlock just those cells and Protect the sheet. The Tab key will move to those cells. 2. Unlock just those cells and Protect the sheet with "select locked cells" unchecked. The ENTER key will move to those cells. 3. No sheet protection necessary. Start with A68 and select those cells using CTRL + click ending with A8. Name that range. From the namebox select your name.....A8 will be the active cell. ENTER your way through the range. Gord Dibben MS Excel MVP >Hi to everybody, >In a worksheet I need to move between certain location (cells); these cells [quoted text clipped - 5 lines] > >Can any one help please. Hi, The first two ways will not work because I need other cells to be unlocked (data must be entered). The third way: I selected the cells & gave a name, when I choose the name all the cells are selected and not a single cell; it seems that it uses the name for all the cells not for a singel cell. Other suggestions?? Khalil > Several methods to do this. > [quoted text clipped - 31 lines] >> >>Can any one help please. Third method........... Yes, all cells are selected but A8 will be active. When you hit ENTER you will move to A68 and through the range of selected cells in order. Gord >Hi, >The first two ways will not work because I need other cells to be unlocked [quoted text clipped - 43 lines] >>> >>>Can any one help please. Thanks a lot, Now it is more clear to me. Khalil > Third method........... > [quoted text clipped - 58 lines] >>>> >>>>Can any one help please. Maybe something like: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B1")) Is Nothing Then Exit Sub Range("A" & 8 + (Target.Value - 1) * 60).Select End Sub Regards Trevor > Hi to everybody, > In a worksheet I need to move between certain location (cells); these [quoted text clipped - 7 lines] > > Can any one help please. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.