Form Control Combo Boxes do not update linked cells when input range changes
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a workbook containing various worksheets each with about two dozen Form Control Combo Boxes.
The input range for the Combo Boxes is on a worksheet within the same workbook and will be regularly updated with new rows. The rows in the input range need to be sorted alphabetically, I cannot just add new rows to the bottom of the range.
When new rows are added to the input range (or the existing rows are reordered), the dropdown menus in the Combo Boxes are updated but selected value is not.
For example, if I have selected the fifth value in the Combo Box dropdown and then add a row to the top of the input range, the Combo Box selection remains the fifth value (and returns what was previously the fourth value in the input range). I want it to adjust to the sixth value so that the returned value remains the same.
Is there a way to have the values in the linked cells update automatically?
microsoft-excel-365
asked Feb 5 at 18:04
TheoTheo
1
add a comment |
I have a workbook containing various worksheets each with about two dozen Form Control Combo Boxes.
The input range for the Combo Boxes is on a worksheet within the same workbook and will be regularly updated with new rows. The rows in the input range need to be sorted alphabetically, I cannot just add new rows to the bottom of the range.
When new rows are added to the input range (or the existing rows are reordered), the dropdown menus in the Combo Boxes are updated but selected value is not.
For example, if I have selected the fifth value in the Combo Box dropdown and then add a row to the top of the input range, the Combo Box selection remains the fifth value (and returns what was previously the fourth value in the input range). I want it to adjust to the sixth value so that the returned value remains the same.
Is there a way to have the values in the linked cells update automatically?
microsoft-excel-365
asked Feb 5 at 18:04
TheoTheo
1
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04
add a comment |
I have a workbook containing various worksheets each with about two dozen Form Control Combo Boxes.
The input range for the Combo Boxes is on a worksheet within the same workbook and will be regularly updated with new rows. The rows in the input range need to be sorted alphabetically, I cannot just add new rows to the bottom of the range.
When new rows are added to the input range (or the existing rows are reordered), the dropdown menus in the Combo Boxes are updated but selected value is not.
For example, if I have selected the fifth value in the Combo Box dropdown and then add a row to the top of the input range, the Combo Box selection remains the fifth value (and returns what was previously the fourth value in the input range). I want it to adjust to the sixth value so that the returned value remains the same.
Is there a way to have the values in the linked cells update automatically?
microsoft-excel-365
asked Feb 5 at 18:04
TheoTheo
1
I have a workbook containing various worksheets each with about two dozen Form Control Combo Boxes.
The input range for the Combo Boxes is on a worksheet within the same workbook and will be regularly updated with new rows. The rows in the input range need to be sorted alphabetically, I cannot just add new rows to the bottom of the range.
When new rows are added to the input range (or the existing rows are reordered), the dropdown menus in the Combo Boxes are updated but selected value is not.
For example, if I have selected the fifth value in the Combo Box dropdown and then add a row to the top of the input range, the Combo Box selection remains the fifth value (and returns what was previously the fourth value in the input range). I want it to adjust to the sixth value so that the returned value remains the same.
Is there a way to have the values in the linked cells update automatically?
microsoft-excel-365
microsoft-excel-365
asked Feb 5 at 18:04
TheoTheo
1
asked Feb 5 at 18:04
TheoTheo
1
asked Feb 5 at 18:04
TheoTheo
1
asked Feb 5 at 18:04
TheoTheo
1
asked Feb 5 at 18:04
TheoTheo
1
1
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04
add a comment |
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402353%2fform-control-combo-boxes-do-not-update-linked-cells-when-input-range-changes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402353%2fform-control-combo-boxes-do-not-update-linked-cells-when-input-range-changes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
How will it know which one you meant? The logical solution is to only add to the end of the list, not the beginning.
– Rory Alsop
Feb 5 at 20:04