The Word userform checkbox (checked/unchecked) is not saved on the Application Quit

gmayor · #4 03-31-2019, 02:29 AM

Basically you would use your close macro to set the document variable e.g.

Code:

Private Sub BtnExitl_Click()
    ThisDocument.Variables("varShow").value = "True"
    ThisDocument.Save
    Application.Quit
End Sub

and then look for that variable when you open the document again. If the variable is not present then show the userform.

Code:

Private Sub Document_Open()
Dim oVar As Variable
Dim bVar As Boolean
    For Each oVar In ThisDocument.Variables
        If oVar.Name = "varShow" Then
            If oVar.value = "True" Then
                bVar = True
                Exit For
            End If
        End If
    Next oVar
    If bVar = False Then UserForm1.Show
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA in Word 2010 to show certain text only when a YES checkbox is checked	kdsim	Word VBA	0	05-16-2018 05:16 AM
Merged Checkbox Fields Always Checked	pdxplorer	Mail Merge	11	12-20-2017 12:37 PM
Checkboxes are unchecked in Listbox that were checked off before.How can I stop this?	Rochelle711	Excel Programming	0	06-22-2014 06:16 PM
Checkbox on Userform result in Text in Word	Dolfie_twee	Word VBA	1	06-22-2010 07:54 AM
Excel 2003 will not terminate with application.quit	Peter Schellenbach	Excel	12	03-14-2006 05:28 PM