![]() |
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