If I understand what you are asking, I think you can use this worksheet
Change event code to do what you want. Just set the correct formulas in the
various Case statements.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Correct As Boolean
If Target.Count 1 Then Exit Sub
If Not Intersect(Target, Range("F3:F10")) Is Nothing Then
Select Case Target.Row
Case 3
Correct = (Target.Formula = "=SUM(A3:C3)")
Case 4
Correct = (Target.Formula = "=LEN(B4)")
'cases 5 thru 10 go here
End Select
If Correct Then
Target.Offset(0, 1).Value = "Correct"
Else
Target.Offset(0, 1).Value = "Try again"
End If
End If
End Sub

Rick

"Tazzy via OfficeKB.com" <u26845@uwe wrote in message
news:808499f0fa3db@uwe...
Hi all,

I'm trying to set up some spreadsheet exercises for some students who are
studying Excel at an intermediate level.

One of the problems that they have to solve involves entering an IF
statement
in cells F3 through to F10

What I want to do is to have the adjoining cells (G3 - G10) show Correct
or
Try again, depending on whether the formula they have used is right. Is
there
a way of entering the formula required into the logical argument of an IF
statement in cells G3 - G10?

Thanks,

Tazzy

--
Message posted via http://www.officekb.com