jparfitt87
New Member
- Joined
- Jul 13, 2012
- Messages
- 23
I have Multipage Userform on which i'm creating a survey. now the survey is going to be used yearly so i'm making more managable.
I've shortened the coding A LOT and i'm now trying to finalised the panikety bits.
the are 5 question sets with 10 questions each. each multipage has 5 quetions.
I want to know if there is a way of hiding 1 single page of the multipage if all of the controls on that page are blank.
I'm thinking something along these lines?
Private Sub MultiPage1_Change()
If Userform.MultiPage1.Pages(1).Controls.Visible = False Then
FrmScope.MultiPage1.Pages(1).Visible = False
End If
End Sub
Regards
Jamie
I've shortened the coding A LOT and i'm now trying to finalised the panikety bits.
the are 5 question sets with 10 questions each. each multipage has 5 quetions.
I want to know if there is a way of hiding 1 single page of the multipage if all of the controls on that page are blank.
I'm thinking something along these lines?
Private Sub MultiPage1_Change()
If Userform.MultiPage1.Pages(1).Controls.Visible = False Then
FrmScope.MultiPage1.Pages(1).Visible = False
End If
End Sub
Regards
Jamie