Overwriting Textbox "Property" Value

Mbrandt5 · #1 01-10-2018, 09:36 AM

The question is how can I use the following method to update the property Value of a textbox, and have it saved as if the userform was created in Visual Basic Editor.

While I know many people have asked this question in the past...
I have not seen answers saying how to execute it with out storing the values in a separate location.

The Saving Would Preferably Save As If The Whole Userform Was Recreated With New Default Values.

Attached is a reference value to the property "Value" that I am referring to.

If anyone knows of a simple code to overwrite Controls default values, it would be greatly appreciated. Below is a possible wrap for it.

Code:

  
Private Sub UpdateControls_Click()

    Dim CTRL As Control

    With ActiveDocument
    
            For Each CTRL In UserForm1.Controls
        
                If (TypeName(CTRL) = "TextBox" or TypeName(CTRL) = "CheckBox") Then
        
                    'OverWrite controls Userform Initialization Value with Current Value 

            Next CTRL

    End With

End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Linking" an arrow to textbox	mferrigno	Drawing and Graphics	1	02-04-2016 03:11 PM
Where can the Document Property "Company Address" be manually edited?	JS411	Word	8	12-17-2015 10:26 PM
Word 2013 "Document Property"	Rude Awakening	Word	2	10-28-2015 08:07 AM
help with compatibility of "WdSaveFormat" property of SaveAs method	ajetrumpet	Word	0	07-15-2013 07:29 AM
Want to search for "class", replacing with document property	YetAnotherAuthor	Word	0	10-30-2009 09:43 AM