how do I get excel to go to a cell?

  [DELETED] 21:16 29 Jul 2003

Hello All
Can anyone tell me the formula to get excel to go to a specified cell if the answer to a question is correct?
I'm trying to write a simple program in excel to aid spelling for learning disabilities, nothing difficult just simple words.
Any guidance would be gratefully received.
By the way it's office97 (yes I know it's old, but so am I).
Thanx All.

  [DELETED] 22:18 29 Jul 2003

Right click the worksheet tab, select View Code.

Copy and paste in the following (from "Private..." to "End Sub"):

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then

If Target.Value Then Application.Goto Reference:=ActiveSheet.Range("D7"), scroll:=True

End If

End Sub

Change "$A$1" to where a True or False result will appear and "D7" to the cell that you want to jump to.

However, if you can state just what it is that you are trying to achieve there may be a more elegant way of telling the user if they were right or wrong.

  [DELETED] 22:46 29 Jul 2003

VoG. I want to get the cliet to spell the name of picture ie apple if the answer is correct then go to the next question (pear or whatever). Basically, just to answer 10 or so questions. I will be using pictures for them to spell the answer.
I shall try your suggestion tomorrow and hopefully complete the project. Cheers.

  [DELETED] 23:03 29 Jul 2003

Well good luck and I hope that it works. As an afterthought you might need to change

If Target.Address = "$A$1" Then

to refer to the cell where the entry is made

and then

If Target.Value Then Application.Goto Reference:=ActiveSheet.Range("D7"), scroll:=True


If ActiveSheet.Range("C5").Value Then Application.Goto Reference:=ActiveSheet.Range("D7"), scroll:=True

Assuming that the crue/False will appear in C5.

  [DELETED] 23:18 29 Jul 2003


This very thing was covered last week in another PC mag. (no where near as good as PCA of course....).

It is an excel sheet and can easily be adapted to include photos/clipart etc.

If you click on the envelope next to my username I an email it to you, as it would be much easier than trying to explain it.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

How to create explosive dance music graphics

When is the best time to buy an iPhone?

Quel antivirus gratuit choisir pour un PC ?