Adding value to drop down list

**neb** · 06-23-2005, 06:23 PM

I have a drop down list that functions using codes to determine a rate of pay by the hour. However, a couple of times a year, the payroll people pay lump sum payments that can vary. Is there a way to write a drop down list with a "blank" so that the user's own data (amount to be paid) of an amount not specified in the drop down list can be added in by the user?

Thanks for any advice in advance.

**BenjieLop** · 06-23-2005, 06:37 PM

Originally Posted by neb

I have a drop down list that functions using codes to determine a rate of pay by the hour. However, a couple of times a year, the payroll people pay lump sum payments that can vary. Is there a way to write a drop down list with a "blank" so that the user's own data (amount to be paid) of an amount not specified in the drop down list can be added in by the user?

Thanks for any advice in advance.

1. Go to Data/Validation/Error Alert
2. Uncheck the box "Show error alert after invalid data is entered."

Hope this is what you are looking for.

Regards.

**neb** · 06-24-2005, 08:35 AM

Well, that was so much easier than I expected! Everything is so simple when you really know how, isn't it?

So wishing I knew more, but ever thankful to others who actually do. Thanks you very much for your help. I don't know what I would do without the suggestions on this board when I get stuck.

neb