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

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
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