Undo button??

[Bruise]

Has anyone ever heard of a code that would function as an undo button? My
spreadsheet requires staff to make many entries throughout the day.
Sometimes they get distracted with phone calls and lose their spot. I would
like to add an 'undo' button that would 'undo' their last 1 or 2 entries. I
thought of just closing without saving, but then they would lose all their
other entries, as well.

Any suggestions?

TIA...
Mark

 

[RB Smissaert]

You will need to keep track of all the changes in such a way that you can
trace back.
For example you could make a VBA collection holding 1-D arrays with 4
elements.

In these array elements you would then have:
Row number
Column number
Cell text or value before change
Cell text or value after change

Any changed cell would add an item to the collection with this information.
If something goes wrong you would just trace back x number of steps.
You would need to work it all out, but it is fairly simple.

RBS

 

[davegb]

Has anyone ever heard of a code that would function as an undo button? My
spreadsheet requires staff to make many entries throughout the day.
Sometimes they get distracted with phone calls and lose their spot. I would
like to add an 'undo' button that would 'undo' their last 1 or 2 entries. I
thought of just closing without saving, but then they would lose all their
other entries, as well.

Any suggestions?

TIA...
Mark

Maybe I'm naive, but what's wrong with the Undo button?

 

[RB Smissaert]

You can't trace back very far with that.

RBS

Maybe I'm naive, but what's wrong with the Undo button?

 

[dominicb]

Good evening dave_gb

The undo button doesn't work to undo a macro - you have to code your
own routine, but you can link it into the undo button, so a user
wouldn't normally notice the difference. This is what the OP was
after.

Bruise

John Walkenbach discusses this with a simple example here:

http://www.j-walk.com/ss/excel/tips/tip23.htm

HTH

DominicB

 

[davegb]

You can't trace back very far with that.

If I remember right, it depends on how much memory you're got. At work,
I've got 1G, so I can go back a long way.

 

[davegb]

Good evening dave_gb

The undo button doesn't work to undo a macro - you have to code your
own routine, but you can link it into the undo button, so a user
wouldn't normally notice the difference. This is what the OP was
after.

I congratulate you! You're psychic!
Clearly, I'm not.

 

[RB Smissaert]

Not sure it depends on available memory.
I got 1G as well, but I can only do 16 undo's.

RBS

 

[Dave Peterson]

You can change the level of undo's in Excel:

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

 

[RB Smissaert]

Thanks; never knew that.
Will stick with 16.

RBS