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

gmayor · #2 01-10-2018, 10:31 PM

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?

Code:

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 · #3 01-11-2018, 07:16 AM

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.

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