Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz.xls
Hi, my friend has sent me a quiz.xls. Iam able to answer few of them. I
thought of finding the answers in the xls. opened the VB editor..but not able to find the code. Please somebody help me how this type of xls are created. and how to find the answers...also please tell me how should I create my own quiz.xls. Thanks a lot. Gautam --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz.xls
Hi
It's a bit hard to comment on this without seeing it but most of these things I've seen aren't reliant on any code. They generally make use of hidden ranges, named ranges, conditional formulae etc. You could find another example of such a thing in the following forum http://www.tek-tips.com/threadminder.cfm?SPID=68 You'll need to search for a thread titled "Cute Quiz" Enjoy ;-) gautamvt wrote in message ... Hi, my friend has sent me a quiz.xls. Iam able to answer few of them. I thought of finding the answers in the xls. opened the VB editor..but not able to find the code. Please somebody help me how this type of xls are created. and how to find the answers...also please tell me how should I create my own quiz.xls. Thanks a lot. Gautam --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz.xls
thanks Loomah, I just found the answers...there is a hidden sheet an
inthat again two columns are hidden..Iam not able to find how to vie those hidden columns but able to view the hidden sheet. each answer i checked against some cells in those hidden columns. what I did is o sheet change event. I am prompting the answers by pointing those hidde cells in the hidden sheet. do you know how to make the hidden columns visible? Thanks, Gauta -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quiz Sheet | Excel Worksheet Functions | |||
Training -- quiz | Excel Discussion (Misc queries) | |||
Simple quiz help | Excel Discussion (Misc queries) | |||
Creating a Quiz... | Excel Discussion (Misc queries) | |||
Quiz... | Excel Discussion (Misc queries) |