ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a varying UserForm using cells from a hidden worksheet (https://www.excelbanter.com/excel-programming/342446-creating-varying-userform-using-cells-hidden-worksheet.html)

Mort 62

Creating a varying UserForm using cells from a hidden worksheet
 
I have been trying to find a way to create a test by using something like a
UserForm or a wizard which calls information from a specific column (the
column which contains the questions) in a worksheet for each test question.
The answer choices would be in different columns in the same worksheet. I am
thinking that using OptionButtons would work well for this. My problem is
that I want to create one form and a formula in the code that changes the
form based on how many answer choices there are (True/False; A, B, C, D, E;
etc.). I would also have a No Answer button
Then at the end of the test I would want to recall any questions that were
given a No Answer so that the taker could re-examine those questions. Can
anyone help me with the specifics?


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com