I have created a worksheet with multiple forms. When I am in Userform1, I have a button the user can click to open Userform2. When they close Userform2 I want Userform1 to update automatically. However, there doesn't seem to be any event, like _click() or _activate() that is occurring just by closing the active form (Userform2). Any suggestions?
I thought possibly if I could call a routine from one form (Userform1) while in another form (Userform2), I could get Userform2 to update that way. Does anyone know if that is possible?
I thought possibly if I could call a routine from one form (Userform1) while in another form (Userform2), I could get Userform2 to update that way. Does anyone know if that is possible?