Activating Cell Based On Test Result

  • Thread starter Thread starter David Graves
  • Start date Start date
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
(e-mail address removed)
 
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
 
Back
Top