Combo Box contents not saving
 

I did some more playing around and found that Excel is not saving Named
Ranges, but it is saving the actual cell references. Is this the way it's
supposed to work?

"Tom Hayakawa" wrote:

Hello all,

I put together a chart with drop down lists using combo boxes, using Tushar
Mehta's site as a guide. After some fiddling, everything worked fine. I
saved the file and went home last night. When I came in this morning and
opened the file, the Control Fields in the combo boxes were all blank. I had
to re-enter the locations for the Input Range and Cell Location. Does anyone
have any ideas why this might happen? Thanks in advance.