Update linked cell reference when copying activex controls

Question

I am developing a survey containing a set of questions that must be answered once for each of several different facilities.  Therefore, I am setting up a matrix with one question per row and one facility per column.

Some of the questions are best answered using combo boxes.  It would be easiest if I could create a combo box in one column, then copy it to each of the other columns.  However, the column reference for the LinkedCell is not updated when I do this, so all the combo boxes end up referencing the same cell.  Is there a way to have the reference automatically updated when I do the copy?  There are almost 400 facilities, so if I have to change the reference manually for each one (then repeat the process for many different questions), it will take me forever!

I want each of the combo boxes (for a single question) to have the same choices, so the fact that the reference for the ListFillRange doesn't change is not a problem.

Thanks for any help you can give me!

hjc

Answer 1

Hi,

Take a look at Debra survey form it will cover your needs

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

Answer 2

Although this example is a bit different from what I am trying to do, it does indeed contain the information I needed -- thank you!

HJ