Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically Put a Value in a specific cell.
Here is what I have:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Range("S7:S37"), Target) Is Nothing Then Worksheets("Daily Log of Students Seen").Range("S38").Value = ActiveCell.Value End If End Sub But, this causes Cell S38 to equal the cell in the target range that is entered. I actually want something else to happen. Once I intercept a cell in the target range and change it, I want Cell S38 to take the value of the changed cell once I exit it. -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Using VB, specific cell data into email subject | Excel Discussion (Misc queries) | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |