Hello, I was wondering what the code would look like if I wanted the following: I would like an command button that when pressed, pops up a user input box that prompts the user for a name. When they enter that name, the code will search through a column of names and delete the one they typed in and shift all of the cells up. If they type in a name that is not on the list, then an error box will pop up. If anyone has any suggestions, your help would be greatly appreciated. Thanks

Sorry I completely forgot about your earlier post. As this is in Excel it is easier to record a macro using the FIND function and DELETE. Although personally I don't like using this function it is good to look at the code and it should just be a case of changing the FIND text to a variable created by the inputbox. You may have to put in a trap for the FIND result if negative as I'm not sure if it automaticaly generates a value if an item is not found. Let me know how you get on and I'll look into this as well.