index > Visual Basic for Applications (VBA) > Textbox won't keep new values after workbook closed

Textbox won't keep new values after workbook closed

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

blackmamba

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

www.dsmyth.net/blog

Derek Smyth

Or use custom document properties, see http://www.cpearson.com/excel/docprop.htm

Navajo

reply 3

You can use google to search for other answers

More Articles

• retrieve data from e-mails to tables

• xcacls.vbs context question

• Opening a MS Access table with combo box

• Task Scheduler

• Automating Microsoft MapPoint.

• Can this be done via an array formula?

• User-defined Excel Input Thoughts?

• Closing a dependent file in Excel97

• Excel Application.MacroOptions and libraries references problems

• vba5.0 doesn't work on dual core computer with Windows2003 system

Welcome to Bokebb New Update Joins the collection

New Articles

• ThisOutlookSession code...
• Run Time Error 1004 On Long Running Stor
• VB writing data to an Excel file
• html tag not working
• Setting the Directory at GetOpenFileName
• Getting Data of HTML page
• Available Resource Error on SaveAs method
• I dont know whether you have come across
• Excel: Treeview handle events for dynami
• Copying rows inside table with vba
• Option Button
• Refreshing web query that is password pr
• Excel Data Read
• How to fill worksheets with HTML
• Collections of control - evaluating the

Hot Articles

• Excel 2000 - macro not found
• How to build this??
• VBA Excel Macro to delete rows based on
• User Input on Range Selection
• Accessing Active Directory trough Access
• How Can I Register The Yahoo DomainKey F
• How to dial a modem and pass a .wav file
• 1004 - Application-Defined or Object-Def
• VBA forms for Excel. Always on top ??
• Help with Run-time error 1004
• Access Doesn't Close after ActiveX is in
• ShellExecute Function
• Doing a date out(radio button)twice wher
• Auto Indentation for VBA
• Accessing a subform control in MS Access

Recommend Articles

• Question reg BeforeDoubleClick event in
• Data from multiple listbox(s) to one array
• Search string
• Problem with Query in VBA code : Object.
• Error with Data refreshing in the backgr
• Wildcards in a "Save As" path
• design web browser.
• Open an excel file
• Adding the VBA Environment to an Applica
• How can I change the font of some of the
• Missing record
• macro that hides rows - excel
• Pasting into a PPT Chart Data Sheet
• Emails via Excel
• code in visual basic to convert decimal