Undo With Excel VBA

JKP Application Development Services.

Microsoft Office Application Development

Undo With Excel VBA

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize

• Class Modules (1) • Class Modules (2) • Implementation • Conclusion •

Search

Zoeken

Go to	Ga Naar
Home Up Class Modules (1) Class Modules (2) Implementation Conclusion

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

Creating An Undo Handler To Undo Changes Done By Excel VBA

Introduction

This article uses techniques not available to Excel 97.

Unlike Word, changes made to an Excel workbook by using VBA cannot be undone easily. One has to write code that:

	Stores the previous state of anything that (possibly) needs to be undone
	Sets a sub to be run when the user selects undo
	Write that subroutine, which reverses the changes last made by your code.

In this article I will demonstrate how one can use two class modules to create a (more or less) generic undo handler which one can plug into any project.

Content

Class Modules (1)
Class Modules (2)
Implementation
Conclusion

statistics

Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2007 JKP Application Development Services.