Why Undo commandbutton is Cleared ?

[halimnurikhwan]

Hi all,

I have a problem if I use :

'>>>>>>>>>>>>>
sub cariorfind()
set findx = activesheet.cells.find(What:="words")
if not findx is nothing then msgbox findx.address
end sub
'>>>>>>>>>>>>>

the undo command lists is cleared after the procedure above,
so I can't undo my previous action...
anyone please help me to answer it ...!

Thank you very much..
regds,
Halim

 

[Duncan]

Halim,


As far as I know, you cannot undo anything done via VBA code.

I may be wrong, but I have noticed this and it has never let me undo
anything I have done through code.

is there a specific action you wish to undo as you may be able to
achieve it with your code, like storing the previous settings and then
restoring after your code?

Duncan

 

[Norman Jones]

Hi Halim,

See John Walkenbach's comments and suggestions at:

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

 

[halimnurikhwan]

Hi Duncan,

As far as I know that's not always but often,
and I think that code not change value in cells or
something that react undo lists...

rgds,
halim


Duncan menuliskan:

 

[halimnurikhwan]

Hi Norman,
I've tried that way... but it seems only undo once ...
How to add the existing undo action lists ... ?
thanks,

hAlim



Norman Jones menuliskan:

 

[Norman Jones]

Hi Halim,

Many macro instructions will destroy Excel's undo list. There is no way to
restore the undo list. If you wish to provide an undo facility for your
macro, you will need to add code to provide your own undo functionality.

In the suggested link, John Walkenbach demonstrates a simple undo strategy.
In his commercially available Power Utility Pak utility, John Walkenbach
provides more complex examples.

In short, however, if you require an undo functionality in your VBA
routines, invariably the onus will be on you to add code to provide such
functionality.