| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
set macro to a cell
How do I set a macro to go to a specific cell when my cursor hits a specified
cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want the cursor to go back to k2. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set macro to a cell
You don't really need a macro for that. If you highlight cells K2:K6 and then
start typing with them highlighted, your cursor will do what you described. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "GAME.ON.GFX" wrote: How do I set a macro to go to a specific cell when my cursor hits a specified cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want the cursor to go back to k2. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set macro to a cell
Correction, I meant if you highlight cells K2:K5 it will do what you describe.
-- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "JBeaucaire" wrote: You don't really need a macro for that. If you highlight cells K2:K6 and then start typing with them highlighted, your cursor will do what you described. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "GAME.ON.GFX" wrote: How do I set a macro to go to a specific cell when my cursor hits a specified cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want the cursor to go back to k2. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set macro to a cell
Attach the following to the worksheet you are working on...
Assumption: The cursor goes to K7 when you enter something in K6 and press Enter... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$K$7" Then Range("K2").Activate End If End Sub "GAME.ON.GFX" wrote: How do I set a macro to go to a specific cell when my cursor hits a specified cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want the cursor to go back to k2. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set macro to a cell
I think you needed to go back to K2 after K5. In that case change $k$7 to $K$6.
However JBeaucaire's suggestion is much better. "Sheeloo" wrote: Attach the following to the worksheet you are working on... Assumption: The cursor goes to K7 when you enter something in K6 and press Enter... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$K$7" Then Range("K2").Activate End If End Sub "GAME.ON.GFX" wrote: How do I set a macro to go to a specific cell when my cursor hits a specified cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want the cursor to go back to k2. Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set macro to a cell
Here's another way If you unlock the specified cells, then protect the sheet and "select Unlocked cells", you will automatically go back to the beginning. -- Stringer ------------------------------------------------------------------------ Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65195 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
