Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Dynamic Questionaire
When you say "create a form" do you mean to have the controls (radio buttons,
checkboxes, text boxes) actually on an Excel worksheet, or are you thinking of a UserForm? If you don't know what I'm talking about when I say UserForm, then the answer is probably "worksheet". The answer is yes in both cases, but which method you're using determines how the values from the controls are obtained and processed. If you plan on setting this all up directly on a worksheet, the way I prefer to do it is to use the controls from the [Forms] toolbar. To get to that toolbar, display it from the Excel menu: [View] | [Toolbars] | "Forms" You just click on a control, and then click on the sheet to put one there and format it up. One of the properties of the Radio buttons and Checkboxes (on their [Control] tab in the properties dialog for each) is what cell they are associated with. When you make a change to the control, the results are reflected in that cell. By pushing a value to the related cell you can change the value of the control. You can set your radio/check boxes up that way, then for text entries, just set up to have the users type directly into a cell on the sheet. Handling controls on Userforms is done differently. As for having a macro decide what to do next, given some change in one of the cells or a click of a button - yes that can be done via code also. Easy way is to have a command button that when clicked takes you to the next step. It could even make a decision based on some value in one of the responses given. Another way to just suddenly jump to another location in the workbook would be to use the worksheet's _Change() event handler to detect a change in a particular cell and take action based on the results of evaluating the change. "jb" wrote: Hi there, I'm trying to create a dynamic questionaire on an excel spreadsheet. I'm wondering: 1) Is it possible to create a form with questions and: a) radio or check boxes, and b) text boxes for user input. 2) If so, how do I get information in and out of these check boxes, 3) Using a Macro to decide which form to go to next. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create an online questionaire | Excel Discussion (Misc queries) | |||
Questionaire to evaluate the level of Excel | Excel Discussion (Misc queries) | |||
Questionaire to evaluate level of Excel | Excel Discussion (Misc queries) | |||
Counting grades in questionaire | Excel Discussion (Misc queries) | |||
Populating a database from a questionaire | Excel Programming |