Hello,
Can someone please help me ? I really appreciate your time and effort in advance.
I created a form called "Form1" with a textbox called "txtpsswd", and another form called "Form2" with a textbox called "txtnewpsswd" and a command button called "Change".
My goal is to replace the value of "txtpsswd" in "Form1" with whatever value I entered in "txtnewpsswd" of "Form2" when I click the "Change" button.
Can you tell me how you reference a control of a form to another control of another form? I know how to do that in MS Access VBA, but not MS Excel VBA. Once again, thank you for your help.
DDTiff
Can someone please help me ? I really appreciate your time and effort in advance.
I created a form called "Form1" with a textbox called "txtpsswd", and another form called "Form2" with a textbox called "txtnewpsswd" and a command button called "Change".
My goal is to replace the value of "txtpsswd" in "Form1" with whatever value I entered in "txtnewpsswd" of "Form2" when I click the "Change" button.
Can you tell me how you reference a control of a form to another control of another form? I know how to do that in MS Access VBA, but not MS Excel VBA. Once again, thank you for your help.
DDTiff