View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mort 62 Mort 62 is offline
external usenet poster
 
Posts: 1
Default 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?