
Christopher Greaves		Home	Contact Me
ON LINE STORE	ON LINE STORE	ON LINE STORE	ON LINE STORE

TorontoVBA.COM

UW.DOT (Word utility functions)

UX.XLA (Excel utility functions)

Covers For Stores

Communicating Data Between Excel And Word

List Numbering In Word

A Means Of Implementing “Undo” On GUI Forms

If you are interested in applications please visit www.VBASolutions.ca .

If you are interested in end-user macros please visit www.TorontoMacros.com .

Recording A Change

A Means Of Implementing “Undo” On GUI Forms ; Legalities ; The GUI Form ; The Data Control Events ; The Preservation Structure ; Initializing The Form ; Recording A Change ; Undoing A Change ; Inhibiting Undo ; Running The Form

Each event on the GUI form allows us to stack a new status of the GUI form within our array of structures.

Function GUI_preserve()    ReDim Preserve typ(UBound(typ) + 1)
    With typ(UBound(typ))
        .blncb1 = Me.cb1
        .blncb2 = Me.cb2
        .blnob1 = Me.ob1
        .blnob2 = Me.ob2
        .blnob3 = Me.ob3
        .strtb1 = Me.tb1
        .strtb2 = Me.tb2
    End With
End Function

Undoing A Change

Contact Me