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



"Bruise" <mkrupiarzATshaw.ca> wrote in message
news:[email protected]...
> 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
>
>

[davegb]

Bruise wrote:
> 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?

[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

[RB Smissaert]

You can't trace back very far with that.

RBS

"davegb" <[email protected]> wrote in message
news:[email protected]...
>
> Bruise wrote:
>> 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?
>

[davegb]

RB Smissaert wrote:
> 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.

>
> RBS
>
> "davegb" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Bruise wrote:
> >> 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?
> >

[davegb]

dominicb wrote:
> 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.

>
> Bruise
>
> John Walkenbach discusses this with a simple example here:
>
> http://www.j-walk.com/ss/excel/tips/tip23.htm
>
> HTH
>
> DominicB
>
>
> --
> dominicb
> ------------------------------------------------------------------------
> dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
> View this thread: http://www.excelforum.com/showthread...hreadid=502683

[RB Smissaert]

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

RBS

"davegb" <[email protected]> wrote in message
news:[email protected]...
>
> RB Smissaert wrote:
>> 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.
>
>>
>> RBS
>>
>> "davegb" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>> > Bruise wrote:
>> >> 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?
>> >
>

[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 wrote:
>
> Not sure it depends on available memory.
> I got 1G as well, but I can only do 16 undo's.
>
> RBS
>
> "davegb" <[email protected]> wrote in message
> news:[email protected]...
> >
> > RB Smissaert wrote:
> >> 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.
> >
> >>
> >> RBS
> >>
> >> "davegb" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >
> >> > Bruise wrote:
> >> >> 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?
> >> >
> >

--

Dave Peterson

[RB Smissaert]

Thanks; never knew that.
Will stick with 16.

RBS

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
>
> 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 wrote:
>>
>> Not sure it depends on available memory.
>> I got 1G as well, but I can only do 16 undo's.
>>
>> RBS
>>
>> "davegb" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>> > RB Smissaert wrote:
>> >> 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.
>> >
>> >>
>> >> RBS
>> >>
>> >> "davegb" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >
>> >> > Bruise wrote:
>> >> >> 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?
>> >> >
>> >
>
> --
>
> Dave Peterson