illecebrousmonk
New Member
- Joined
- Aug 15, 2011
- Messages
- 4
Here's what I need, which should be simple, but I'm just learning still.
I need a script which will monitor a cell, A1 (whose value is set by a function on another sheet) and when A1 has a specific value ("home") then it will set the values of three target cells (A2, B2, C2) to three different values ("red", "loud", and "happy").
Here's what I have so far, but when triggered it only sets the first target cell (A2) to its value ("red") and doesn't do anything with the second and third target cells.
Please help.
Thanks!
I need a script which will monitor a cell, A1 (whose value is set by a function on another sheet) and when A1 has a specific value ("home") then it will set the values of three target cells (A2, B2, C2) to three different values ("red", "loud", and "happy").
Here's what I have so far, but when triggered it only sets the first target cell (A2) to its value ("red") and doesn't do anything with the second and third target cells.
Private Sub Worksheet_Calculate()
If Range("$A$1") = "home" Then
Range("$A$2") = "red"
Range("$B$2") = "loud"
Range("$C$2") = "happy"
End If
End Sub
Please help.
Thanks!