I have 2 userforms. On the main form, there is a button called "Setting". Click on it will bring up the second form. On the second form, there is a textbox1 which has it's value defaulted to "abc". There is another button called "SaveAndQuit". Click on it will close the form #2 and return to form #1.
If I don't change any thing, textbox1.value will always be "abc", but I want my program to remember the change I made to textbox1. That is, when an user typed "efg" to textbox1 and click "SaveAndQuit", textbox1.value should be changed to "efg". When that user click "Setting" again, he will see textbox1 is "efg" instead of "abc".
The textbox1.value will be set back to default "abc" after all operation finished. That means, the value change made to textbox1 is not permanent to the program.
Private sub userform_initialize()
textbox1.value="abc"
end sub
Private sub textbox1()
end sub
private sub SaveAndQuit()
unload form2
end sub
Thanks!
If I don't change any thing, textbox1.value will always be "abc", but I want my program to remember the change I made to textbox1. That is, when an user typed "efg" to textbox1 and click "SaveAndQuit", textbox1.value should be changed to "efg". When that user click "Setting" again, he will see textbox1 is "efg" instead of "abc".
The textbox1.value will be set back to default "abc" after all operation finished. That means, the value change made to textbox1 is not permanent to the program.
Private sub userform_initialize()
textbox1.value="abc"
end sub
Private sub textbox1()
end sub
private sub SaveAndQuit()
unload form2
end sub
Thanks!