VBA Codes to Control Flow Among Multiple Userforms

[Kabirch]

I want to develop a Survey Form in Excel 2003 using userforms. The Survey Form would have two pages. When the first page is submitted, the second page of the Survey Form would open on the screen. However, the second page of the Survey Form would have 3 alternatives. Depending on the age of the customer that is provided in the first page of the Survey Form, ONLY ONE alternative of the second page of the Survey Form would open on the screen. What would be the VBA codes to achieve this conditional sequencing among multiple userforms?

 

[knight00779]

Hi,


Something like Global Variable (as in scope of variable) which would be shared across different forms

Hope this helps.