I want to use a userform to build & edit an email distribution list in Sheet 1 Column G. I would like to do this with 2 TextBoxes, and 3 Command Buttons, to perform the following objectives.
1. email address entered in textbox1, pressing commandbutton1("add") would input value into sheet1.g1. Once data is in sheet1.g1 that address would be visible in textbox2.
2. select email address in textbox2, press commandbutton2("edit"), press commandbutton1 (overwrites the existing data)
3. select email address in textbox2, press commandbutton3("delete"), record disappears from textbox2, any existing data in that column moves up so no gaps are in that column.
I hope this is not too much of a request. Thanks for any help.
1. email address entered in textbox1, pressing commandbutton1("add") would input value into sheet1.g1. Once data is in sheet1.g1 that address would be visible in textbox2.
2. select email address in textbox2, press commandbutton2("edit"), press commandbutton1 (overwrites the existing data)
3. select email address in textbox2, press commandbutton3("delete"), record disappears from textbox2, any existing data in that column moves up so no gaps are in that column.
I hope this is not too much of a request. Thanks for any help.
