drmidnight
New Member
- Joined
- Jun 27, 2018
- Messages
- 5
Hoping for help with this, which is probably obvious to someone who knows more vba than me. I am v much a beginner learning as i go. My excel sheet 1 is connected to an api, so using Private Sub Worksheet_Change(ByVal Target As Range), and With Target.Parent etc.
From sheet 1 I want to for example query the value of cell C2 in sheet 4 and if true place a different value in cell D1 in sheet 1. Have tried vba along the lines of but no joy with:
If Worksheets("Sheet4").Range("C2").Value = 10 Then
.Range("D1").Value = 15
End If
Project explorer is set to show sheet 4 as Sheet4 (Data)
Is this relevant. ? Would really appreciate help with the correct code on this.
From sheet 1 I want to for example query the value of cell C2 in sheet 4 and if true place a different value in cell D1 in sheet 1. Have tried vba along the lines of but no joy with:
If Worksheets("Sheet4").Range("C2").Value = 10 Then
.Range("D1").Value = 15
End If
Project explorer is set to show sheet 4 as Sheet4 (Data)
Is this relevant. ? Would really appreciate help with the correct code on this.