Option/ Tick/ Combo box help :)

[Karl]

Hello,

I have been tasked with creating a "self assessment" questionnaire for colleagues where we can then take the data they enter to create graphs & identify training requirements.

Do option boxes etc, have the ability to give a data out put?

For example colleague selects that they are "able to train others" can the option box give a value out of say '4 or even simply what they have selected?

Any help would be greatly appreciated.

Regards

Karl

 

[Mike H..]

Hello,

I have been tasked with creating a "self assessment" questionnaire for colleagues where we can then take the data they enter to create graphs & identify training requirements.

Do option boxes etc, have the ability to give a data out put?

For example colleague selects that they are "able to train others" can the option box give a value out of say '4 or even simply what they have selected?

Any help would be greatly appreciated.

Regards

Karl

Hi,

See this very simple example. I inserted a checkbox and linked it to cell G1; I hid column G, then put a simple formula in H1.

Now if you check the checkbox h1 returns 4.

 

[NARAYANK991]

Hi Karl ,

You can certainly collate data from a questionnaire , provided the questionnaire does not involve any free text answers.

Both Option Buttons ( also called Radio Buttons ) and Check Boxes give a TRUE / FALSE or 1 / 0 or a Checked ( Clicked / Selected ) / Unchecked ( Not Clicked / Deselected ) output i.e. the output of both these controls is binary , admitting of only 2 possibilities.

Since these controls have what is called a Cell Link or LinkedCell , their output can be made available in a worksheet cell , so that either VBA code or worksheet formulae can make use of them.

Check Boxes are used in situations where multiple answers to a question are possible e.g. if you have to check the languages you know from a displayed set of say 10 languages , you will use Check Boxes , so that the user can check multiple Check Boxes.

Option Buttons are used where only one answer to a question is possible , and this answer is to be chosen from the several that are available e.g. How would you rate Microsoft Excel ? The answers available can range from Wonderful to Rubbish , and the user is expected to choose one from the several answers available.

You can also have other controls to input numeric data , such as spinners , controls to select one or more options from a set of available choices , such as List Boxes , Combo Boxes ,...

The first step is to create a database worksheet of all the questions and their answers ; thereafter , you can plan how you wish to go about posing the questions ; either it is a printable paper and pencil question paper , or it can even be done on the computer.

A simple example is available here :

http://www.contextures.com/xlForm01.html

Narayan