Quote Originally Posted by JosephP View Post
the input range isn't being changed so that's not an issue. is there a reason you can't unlock the linked cell?
The main reason why cells are locked is because users who are not so computer savvy may inadvertently delete cells that they shouldn't, thus compromising the programming. So all cells are locked, except the ones for data entry.

The user uses the "ComboBox" to make a selection and thus "changes" his choice based on the input range. And his choice generates a different result in the "Cell Link."