Thread
:
When a cell is merely selected, executed an evaluation?
View Single Post
#
8
Don Guillett
Posts: n/a
typed Don into cell p10 then I got "type mismatch"
Feel free to always email me about anything.
But, I don't know much about that music festival.
--
Don Guillett
SalesAid Software
"Bob Phillips" wrote in message
...
Not giving up that easily Don <vbg
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$Q$10" Then
Range("P10").Value = CBool(Not Range("P10").Value)
End If
End Sub
BTW Okay to mail you off-line about next Year's South-West Fest?
--
HTH
Bob Phillips
"Don Guillett" wrote in message
...
I tried that but you must start with true or false IF op really wants
that.
--
Don Guillett
SalesAid Software
"Bob Phillips" wrote in message
...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$Q$10" Then
Range("P10").Value = Not Range("P10").Value
End If
End Sub
--
HTH
Bob Phillips
"Don Guillett" wrote in message
...
try
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$10" Then
If UCase(Range("B10")) = "TRUE" Then
Range("B10") = "FALSE"
Else
Range("B10") = "TRUE"
End If
End If
Cancel = True
End Sub
--
Don Guillett
SalesAid Software
"CRayF" wrote in message
...
Is there a way to code this so I toggle this.
If Q10 is selected again it will toggle P10 back to FALSE?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$Q$10" Then
Range("P10").Value = "TRUE"
End If
End Sub
Reply With Quote