New value in list column causes repeated dialog errors

[Guest]

I have a worksheet with stock transactions. The first column's heading is
"acct" representing an acronym indicating which investment account the
transaction is in.

Now that I'm in Excel 2003 I'm using the List functionality on the sheet.
(The sheet started long before that feature existed.) The ability to use
AutoFilter to see rows for a particular account is very nice. But I now have
a problem.

I entered a row with a new acct value, and got a dialog with title
"Microsoft Excel", text "Invalid acct: <newvalue>", and an OK button. That
seemed reasonable, as it was not one of the values already in the acct
column. However, I can't make those messages go away! After adding multiple
rows with the same new value, and with a different new value for testing,
every time I move into or off of the list, I get one error dialog for each
row that has one of those new values. (Ugh.)

I tried turning the list back to a normal range, then turning it into a list
again -- still the same errors appear. Somewhere, it seems, is a list of the
"valid" values in the acct column. (It's not the same as the list of values
in the dropdown when AutoFilter is on; that list includes the new values.)

How do I update the invisible list of valid values for that column? Or, how
can I make this go away in some other fashion?

Thanks.

 

[Guest]

Pretend you never saw this. (Or, as Gilda Radner said, "Never mind.")

The messages came from a VB function named TaxableAcct whose intent was to
determine, from the account acronym, whether the account is taxable. When an
account it didn't know is encountered, it displayed the message I'm seeing;
so I got it whenever things recalculated. SIgh.

I just had to add the new acronyms to either the taxable or not-taxable
lists in the function. (I also made the message say "edit vb function
TaxableAcct to fix.")

<blush/>