Activating Cell Based On Test Result

[David Graves]

Can I activate a specified cell based on the TRUE/FALSE
result of a test question? I want 'true' to make a
specific cell active, 'false' activates a different cell.

Cheers,
David Graves
(e-mail address removed)

 

[Gord Dibben]

David

Formulas can return results only in the cell in which they reside.

VBA code can do what you ask.

Sub gronk()
If Range("j4").Value = True Then
Range("j5").Select
Else
Range("j8").Select
End If
End Sub

Gord Dibben Excel MVP