Activating Cell Based On Test Result

D

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
[email protected]
 
G

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
 
Top