Hello,
I have this issue,
I have a Textbox on a Userform that loads when a workbook is opened. If a user modifies the content of that textbox even if the workbook is saved the new values are not kept the next time that workbook is opened.
How can I save the new values
I would prefer not to store those values in a cell and then load them in the textbox each time the workbook is open. Is there another way
Thanks
Textbox won't keep new values after workbook closed
Hot Topic
- One COM Add-in for all versions of Office (2000 and up)?
- ShellExecute Function
- LBound and UBound functions
- Attempted to read or write protected memory. This is often an indication that other memory is corrupt
- Need to Count the replacements made by a VBA macro in a Word 2003 doc
- OleDbConnection to Excel
- Advanced Find - CRoss Table Searches Possible?
- How can I connect to the Team Foundation server?
- Microsoft....Is this a joke? (email received from customer service at microsoft)
- VBA sheet using registered dll functions across a network
Microsoft ISV
- Building dynamic forms in Access
- % comleted box
- Can't open regedit
- How do I open CSV using Excel without deleting leading zeros?
- Attaching Contents of a Folder
- row height
- CRM 3.0 doesn’t save my settings
- Userform Controls
- how to close a userform in workbooks.open method
- iexplore.exe - Application Error
Textbox won't keep new values after workbook closed
GoDaddy
the only other way is to save the data to file or to a database.... I posted an article on saving userform state that might be helpful here...
http://dsmyth.blogspot.com/2006/05/saving-user-interface-state.html
ForEverLearning
CarmineM
Problem solved.