Overwriting Textbox "Property" Value

[Mbrandt5]

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.

  
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

[gmayor]

What is the point of this exercise? Why not simply set the changed properties of the controls as you need them when you call the userform?

Sub Example()
Dim ofrm As New UserForm1
Dim oCtrl As Control
    With ofrm
        For Each oCtrl In ofrm.Controls
            If (TypeName(oCtrl) = "TextBox" Or TypeName(oCtrl) = "CheckBox") Then
                With oCtrl
                    .Font.Size = 12
                    .Font.Name = "Calibri"
                    .Width = 120
                End With
            End If
        Next oCtrl
        .Show
        Unload ofrm
    End With
    Set ofrm = Nothing
End Sub

[Mbrandt5]

Why make facebook when myspace was available.

Better GUI.
Less Storage Requirements.
Less Electricity.
Less Data Usage /\.
More Free Time.

Just to name a few.

Your code is much different than what I inquired about.