LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a chart with varying data value ranges Anthony Blackburn Excel Discussion (Misc queries) 1 May 17th 10 05:41 PM
Creating Macros to work with ranges of varying sizes Excel Grasshopper Excel Programming 3 August 26th 05 05:55 AM
Can specific cells on a worksheet be hidden & password protected? Ann Excel Worksheet Functions 6 July 5th 05 09:08 PM
Creating a table from one varying source Rumblefish Excel Programming 1 June 9th 04 02:08 PM
data from userform into worksheet cells Newbie1 Excel Programming 2 February 9th 04 09:55 PM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"