jyablinsky
New Member
- Joined
- Dec 29, 2008
- Messages
- 33
Hello,
I have a userform that has about 40 input fields and an execute button that creates a quote/enters data into a data spreadsheet/etc. Once I click the "Generate Quote" commandbutton, the 40 inputs disappear the next time I open the userform. If I make one small mistake, I have to re-enter all 40 fields. Is there an option or code that will save the data in the fields when I reopen the userform? And can I put a "Clear Fields" commandbutton on the userform to clear all the information? Any help would be GREATLY APPRECIATED. Thanks in advance.
Jason
I have a userform that has about 40 input fields and an execute button that creates a quote/enters data into a data spreadsheet/etc. Once I click the "Generate Quote" commandbutton, the 40 inputs disappear the next time I open the userform. If I make one small mistake, I have to re-enter all 40 fields. Is there an option or code that will save the data in the fields when I reopen the userform? And can I put a "Clear Fields" commandbutton on the userform to clear all the information? Any help would be GREATLY APPRECIATED. Thanks in advance.
Jason