Hello,

I am trying to see if I can get a macro to open up a UserForm when I select a name that is inputted into column A. When the cell is selected I what it to open my UserForm named Address which calls on the address tab and inputs the information that matches the name selected. Also on the Address Form I can select a button that calls up a different sheet that has assignment scores and inputs that data into the new form, etc, etc. I tried to do some of the script from what I have read on my google searches. I also have a find and replace userform that I have absolutely no idea how to code it to find a name and list the address and then save it to that row. I have a crude example and any help would be much appreciated. Example.xlsm