Excel forms controls

[rob]

I want to put a survey with numerous multiple choice questions into
Excel and use several forms controls, like Spinner, Scroll bar, List
box and Combo box. I have set up one row, with the controls in a
separate column to the left of the target data column, and that works
fine. However, I need to establish enough rows for 200 survey
respondents.

Here is my question (using the Combo box as the example): If I have
it set up in B1 to place the data in cell A1, is there any way to
automate the process of placing the same box accessing the same source
data in each successive row with manually inserting a new Combo box
and changing the target cell each time? I.E. place it in B2 to enter
data into B1, etc.

Thanks for any help.

Rob

 

[Leith Ross]

I want to put a survey with numerous multiple choice questions into
Excel and use several forms controls, like Spinner, Scroll bar, List
box and Combo box. I have set up one row, with the controls in a
separate column to the left of the target data column, and that works
fine. However, I need to establish enough rows for 200 survey
respondents.

Here is my question (using the Combo box as the example): If I have
it set up in B1 to place the data in cell A1, is there any way to
automate the process of placing the same box accessing the same source
data in each successive row with manually inserting a new Combo box
and changing the target cell each time? I.E. place it in B2 to enter
data into B1, etc.

Thanks for any help.

Rob

Hello Rob,
Placing that many controls on a worksheet will severly increase the
processing overhead. You may wnat to consider place your controls on a
VBA UserForm. The questions could be sequentially displayed to the
user from the worksheet and the answer transfered back to the
appropriate place on the worksheet. This would be easier to expand and
maintain as well.

Sincerely,
Leith Ross