I've written a program in VBA such that it opens up a dialog box, and I
choose the name of the person i want selected from a list, and then hit
enter, and it copies that name to a separate list. However, I do not
know how to write the formula so that after it chooses the name off of
a list and enters it into another name, it then deletes itself off the
original list.

Thanks,