I created a datasheet in excell that I email out to users. I would like them to enter updates. I password protect the sheet so that they can only make changes to the third column (updates only). I ended up adding combo boxes to some of the rows, without knowing that the comboboxes are objects instead of regular validation.
I may have to hand enter the completed form values from persons that already sent the form back. I have two questions, how do you read in the combobox value selected? If you can not do this, can you suggest some VBA code to create a value list drop down in a cell that is based off another cell value range? In the second approach, during the next collection, I would hide the value list and protect the sheet so users could not edit it.
I've attached a sample sheet to demonstrate the drop down (combobox) that does not currently import correctly.