Adding value to drop down list
 

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.


--
neb
------------------------------------------------------------------------
neb's Profile: http://www.excelforum.com/member.php...o&userid=17597
View this thread: http://www.excelforum.com/showthread...hreadid=381791

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

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


--
neb
------------------------------------------------------------------------
neb's Profile: http://www.excelforum.com/member.php...o&userid=17597
View this thread: http://www.excelforum.com/showthread...hreadid=381791

Thank you for the feedback ... just glad that I can help.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381791