I have a worksheet that some of our staff uses to input their hours into.
Under a client section, they have a list box that allows them to select the
client they are working for. However, I want them to be able to add a new
client if it is not already listed.

I have a button at the bottom that they can click. What I wold like to see
happen is have a Message Box pop up and ask them for the name of the new
client. When they hit OK, it adds the client to the list in alphabetical
order where the validation is pulled from (no more than 500 clients). On top
of that, when they hit OK on the Message Box, Excel will actually create a
new tab at the bottom, cahnge the name of that tab to the client's name, and
put it in alphabetical order with the other tabs aready in existance.

Any help would be appreciated. I am using Excel 2003 on Windows Server
2003. Thanks!

Aaron