If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Designing a question paper
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 (remove nospam) Many thanks Regards Ken |
#2
|
|||
|
|||
Designing a question paper
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 "Ken" wrote in message ... 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 (remove nospam) Many thanks Regards Ken |
#3
|
|||
|
|||
Designing a question paper
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 "David McRitchie" wrote in message ... 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 "Ken" wrote in message ... 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 (remove nospam) Many thanks Regards Ken |
Thread Tools | |
Display Modes | |
|
|