neb Wrote:
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.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=381791