Excel Combo Box edit Data range dont save?

%3CLINGO-SUB%20id%3D%22lingo-sub-2072669%22%20slang%3D%22en-US%22%3EExcel%20Combo%20Box%20edit%20Data%20range%20dont%20save%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072669%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20my%20dear%20friends%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20here%20familiar%20with%20Combo%20Boxes%20in%20Excel%20and%20could%20give%20a%20hint%20or%20two%20to%20why%20I%20cant%20edit%20the%20data%20range%20of%20the%20drop%20down%20list%20I%20created%20with%20my%20Combo%20box%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20here%20is%20the%20scenario.%20I%20made%20a%20excel%20to%20keep%20track%20of%20my%20services%20in%20a%20game%2C%20so%20I%20could%20track%20what%20I%20am%20doing%20and%20what%20I%20get%20from%20it%20and%20how%20much.%20When%20I%20first%20made%20it%20I%20found%20a%20guide%20how%20to%20make%20a%20interactive%20dropdown%20Combo%20Box%20-%20So%20I%20followed%20it%2C%20at%20some%20point%20I%20realized%20I%20didnt%20need%20ALL%20of%20the%20functions%20so%20I%20stopped%20and%20had%20a%20fully%20working%20drop%20down%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%202%20months%20later%2C%20I%20want%20to%20add%203%20new%20items%20to%20my%20drop%20down%20list%2C%20but%20it%20dont%20want%20to%20make%20the%20list%20%22longer%22.%20So%20if%20I%20edit%20the%20items%20on%20the%20original%20range%2C%20they%20will%20change%20in%20the%20drop%20down%20list%2C%20but%20if%20i%20want%20to%20add%20more%20items%2C%20it%20just%20dont%20see%20them.%20(As%20they%20fall%20outside%20the%20original%20range)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20trying%20to%20force%20it%20to%20see%20the%20new%20longer%20range%2C%20edit%20how%20many%20lines%20it%20shows%2C%20ect%20but%20it%20just%20'dont%20save%20it'%3F%20I%20managed%20to%20edit%20how%20many%20it%20shows%2C%20and%20it%20would%20take%20the%20new%20info%2C%20but%20when%20I%20tried%20to%20tell%20it%20the%20new%20range%20it%20just%20went%20back%20to%20previous%20range%20after%20I%20closed%20the%20window.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20combo%20box%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dejna_0-1611016042133.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247358iB1A0DCE6F824779A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dejna_0-1611016042133.png%22%20alt%3D%22Dejna_0-1611016042133.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20the%20data%20on%20a%20separate%20page%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dejna_1-1611016062797.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247359iF93472237F98C5A4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dejna_1-1611016062797.png%22%20alt%3D%22Dejna_1-1611016062797.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%20is%20the%20data%20range%20in%20the%20Settings%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dejna_2-1611016154106.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247360i64276B9C39B1BC20%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dejna_2-1611016154106.png%22%20alt%3D%22Dejna_2-1611016154106.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20this%20is%20the%20settings%20I%20am%20adding%20that%20it%20just%20dont%20seem%20to%20like%3A%20(note%20only%20changed%20the%20last%20number%20from%20(1)2%20to%20(1)5).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dejna_3-1611016179012.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247361iDDF95B408B1F45A5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dejna_3-1611016179012.png%22%20alt%3D%22Dejna_3-1611016179012.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20exiting%20the%20Designmode%2C%20it%20works%20and%20shows%20everything%20-%20but%20the%20moment%20I%20click%20somewhere%20else%20and%20go%20back%20to%20the%20same%20cell%20it%20just%20go%20back%20to%20the%20old%20range...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dejna_4-1611016445617.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247362i620C907B6B5A3BE6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dejna_4-1611016445617.png%22%20alt%3D%22Dejna_4-1611016445617.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20all%20out%20of%20ideas%20why%20it%20would%20behave%20like%20this%20%3CLI-EMOJI%20id%3D%22lia_confused-face%22%20title%3D%22%3Aconfused_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Anyone%20has%20seen%20this%20before%3F%20Know%20something%20I%20missed%3F%20Thank%20you%20in%20advance%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2072669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello my dear friends

 

Anyone here familiar with Combo Boxes in Excel and could give a hint or two to why I cant edit the data range of the drop down list I created with my Combo box?

 

So here is the scenario. I made a excel to keep track of my services in a game, so I could track what I am doing and what I get from it and how much. When I first made it I found a guide how to make a interactive dropdown Combo Box - So I followed it, at some point I realized I didnt need ALL of the functions so I stopped and had a fully working drop down list.

 

Now, 2 months later, I want to add 3 new items to my drop down list, but it dont want to make the list "longer". So if I edit the items on the original range, they will change in the drop down list, but if i want to add more items, it just dont see them. (As they fall outside the original range)

 

I have been trying to force it to see the new longer range, edit how many lines it shows, ect but it just 'dont save it'? I managed to edit how many it shows, and it would take the new info, but when I tried to tell it the new range it just went back to previous range after I closed the window.

 

This is my combo box:

Dejna_0-1611016042133.png

This is the data on a separate page:

Dejna_1-1611016062797.png

Here is the data range in the Settings:

Dejna_2-1611016154106.png

 

And this is the settings I am adding that it just dont seem to like: (note only changed the last number from (1)2 to (1)5).

Dejna_3-1611016179012.png

 

After exiting the Designmode, it works and shows everything - but the moment I click somewhere else and go back to the same cell it just go back to the old range...

 

Dejna_4-1611016445617.png

 

I am all out of ideas why it would behave like this Anyone has seen this before? Know something I missed? Thank you in advance

 

 

 

0 Replies