don't link it. use code to populate the cell in the change event of the combobox (or the assigned macro if it's a Forms control)
don't link it. use code to populate the cell in the change event of the combobox (or the assigned macro if it's a Forms control)
Josie
if at first you don't succeed try doing it the way your wife told you to
Okay that sounds good, only if I knew how to do that. Keep in mind though, there are other VB code and worksheets that are feeding off of the information that cell link provides. Thoughts?
Also of note, the "Input Range" remains locked, and the comboBox still works. However, only the "Cell link" is the issue when locked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks