| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
want J1 to reflect the value of a:2:a500 as the cursor enters the
want J1 to reflect the value of a:2:a500 as the cursor enters the row
But how? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
want J1 to reflect the value of a:2:a500 as the cursor enters the
Right click on the sheet tab that you want to react to the change in cursor
location and select view code. Paste the following code... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row = 2 And Target.Row <= 500 Then Range("J1").Value = Cells(Target.Row, "A").Value End If End Sub -- HTH... Jim Thomlinson "Gordy99" wrote: want J1 to reflect the value of a:2:a500 as the cursor enters the row But how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autosum automatically enters zero | Excel Worksheet Functions | |||
| Putting Cursor in Cell A1 of each Worksheet, then ending cursor on smalest sheet name according to VBA Editor | Excel Programming | |||
| Excel forms enters .exd in registry | Excel Programming | |||
| Date enters wrong #'s | New Users to Excel | |||
| find/replace enters | Excel Discussion (Misc queries) | |||
Linear Mode
