Excel 2010. I am confused by form control combobox functionality. I've tried this both programmatically with .addformcontrol and non-programmatically with Insert->Combobox from the menu. The outcome is the same.
I have a range named foo. It is the possible values for a form control combobox.
If I create a combobox in bar with .listfillrange = range("foo") and then .listindex = 1, the first item in the combobox is selected.
However, if I save the file and then close it, when I re-open the file, the combobox has had option 1 deselected. The options all exist there in the combobox, but it is displaying none of them.
This does not happen if I select option 2 or 3 or so forth, save, close, and re-open.
I created a combobox non-programmatically and the same thing happens. If I pick Option 1, save, close, and re-open, blank. If I pick any other option, save, close, and re-open, the correct selection persists.
This is all done in a file that is saved without macros. There is no VBA acting upon the file when I close it or re-open it.
Why is this happening, and how can I fix it?
Thanks!
Here is a visual example of what I mean. Upon opening the file, this is what two of the comboboxes look like. The first *was* set to the first option before saving, closing, and re-opening. The second was set to the second option. http://imgur.com/1jZpwaB,Zh7Jpds#0
Here I have expanded the first combobox by clicking on the arrow. As you can see, the options are there! The combobox just loads up with none of them selected upon opening. http://imgur.com/1jZpwaB,Zh7Jpds#1
Bookmarks