Designing a question paper

[Ken]

Could anyone please help. I am relatively new to Excel and am trying to
design a question paper where the student has to fill in the answer box.

What I would like to do is to only display the first question when the
spreadsheet is opened. Once the student fills in the answer to question 1,
the second question will then be displayed and so on.

Any help appreciated.

Please reply to group or to (e-mail address removed) (remove
nospam)

Many thanks

Regards

Ken

 

[David McRitchie]

You could use an Event macro to unhide the next row when
a value is entered in Column B. You would start with column
B empty and rows after your first question hidden.

place the following code by right click on the sheet tab, then
View Code, place code. Applies only to the one sheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Rows(Target.Row + 1).EntireRow.Hidden = False
End Sub

 

[Ken]

David
Very many thanks - that works fine - I still need to tidy up the question
paper but you have given me the start that I needed.

Regards

Ken

You could use an Event macro to unhide the next row when
a value is entered in Column B. You would start with column
B empty and rows after your first question hidden.

place the following code by right click on the sheet tab, then
View Code, place code. Applies only to the one sheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Rows(Target.Row + 1).EntireRow.Hidden = False
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Could anyone please help. I am relatively new to Excel and am trying to
design a question paper where the student has to fill in the answer box.

What I would like to do is to only display the first question when the
spreadsheet is opened. Once the student fills in the answer to question 1,
the second question will then be displayed and so on.

Any help appreciated.

Please reply to group or to (e-mail address removed) (remove
nospam)

Many thanks

Regards

Ken