GreenTree
01-15-2007, 05:13 PM
Hello!
I'm using VBA and several worksheets to do a lot of processing on a bunch of data from text files. One of the first things needed is that the user selects a city (using a 3-letter airline code) out of a list, also a month and a year, and a couple of yes/no's. I use combo boxes for all of these, in each case referring to a range on the same worksheet for the possible values. Then, based on what's selected, when the user clicks on a button, the processing commences. Everything works fine to this point.
What's goofy is this: after the initial processing, the user can click another button to go to a "display" worksheet, and move around the data. When I select the original "welcome" sheet again where I'd expect to be able to select a different city or month or change a yes/no, the combo boxes all have NOTHING in them when I click the drop down arrow... no cities to choose from, no months, nada. The previously selected values are still there, but nothing else. The range is still on the spreadsheet below, and when I look at the Properties for the combo box, the ListFillRange still points where it should. AND, when I save the spreadsheet, exit Excel, and reload, everything works fine (until I do the number grinding, and the problem shows up again like clockwork).
I'd post the spreadsheet, except that without the external data there's no processing to be done, and the external data is (a) huge, and (b) slightly private, and I don't have any idea how to de-identify the data without making it impossible to process.
Using Excel 97. Utter novice to VBA. No code associated with any of the combo boxes.
If this sounds like a known issue that anybody's seen before, I'd be very grateful for any fixes. If this is falling into the "sounds strange, no guess what's going on until I see it" category, I may be out of luck & need to go about this some other way.
Many thanks!
I'm using VBA and several worksheets to do a lot of processing on a bunch of data from text files. One of the first things needed is that the user selects a city (using a 3-letter airline code) out of a list, also a month and a year, and a couple of yes/no's. I use combo boxes for all of these, in each case referring to a range on the same worksheet for the possible values. Then, based on what's selected, when the user clicks on a button, the processing commences. Everything works fine to this point.
What's goofy is this: after the initial processing, the user can click another button to go to a "display" worksheet, and move around the data. When I select the original "welcome" sheet again where I'd expect to be able to select a different city or month or change a yes/no, the combo boxes all have NOTHING in them when I click the drop down arrow... no cities to choose from, no months, nada. The previously selected values are still there, but nothing else. The range is still on the spreadsheet below, and when I look at the Properties for the combo box, the ListFillRange still points where it should. AND, when I save the spreadsheet, exit Excel, and reload, everything works fine (until I do the number grinding, and the problem shows up again like clockwork).
I'd post the spreadsheet, except that without the external data there's no processing to be done, and the external data is (a) huge, and (b) slightly private, and I don't have any idea how to de-identify the data without making it impossible to process.
Using Excel 97. Utter novice to VBA. No code associated with any of the combo boxes.
If this sounds like a known issue that anybody's seen before, I'd be very grateful for any fixes. If this is falling into the "sounds strange, no guess what's going on until I see it" category, I may be out of luck & need to go about this some other way.
Many thanks!