Undo Button

[jabawalkie5000]

I have a macro that brings up a user form that allows me to chose from a tab called "sheet1" which files I want to open. "Sheet1" is an import listing files from a particular directory. Selected files are stored in a tab called "list". This user form has two buttons on it, "ok" and "close". "ok" is to select a file, "close" is to finish after selection. I want an undo button that can allow you to undo previous selection in turn in reverse order. Similar to the undo function in excel, can you help with this?

Thanks

 

[Michael M]

Hi
This is not necessarily an easy process. VBA clears the undo stack when a macro is run, so there is no data to undo to!!
I guess you could store the data that changes, as a variable and call it back if there is an error.....but I can't imagine that being efficient if there was a lot of it !!

 

[jabawalkie5000]

There will only ever be no more than 30 files so 30 records tops. If this is not easy, can you do a coding that asks vba to clear down and restart selection?

Hi
This is not necessarily an easy process. VBA clears the undo stack when a macro is run, so there is no data to undo to!!
I guess you could store the data that changes, as a variable and call it back if there is an error.....but I can't imagine that being efficient if there was a lot of it !!

 

[Michael M]

I may have been a little conservative in my comments.....rather than saying "not easy", I probably should have said...."can't do".
Maybe your current code could be changed to clear all the imported files, so that you can re import a new selection.
If that is an option....post the code you already have.
I may not get a look at it tonight, but will be back online tomorrow afternoon.

 

[jabawalkie5000]

Thanks, done a restart again command button, clears down the lot.

I may have been a little conservative in my comments.....rather than saying "not easy", I probably should have said...."can't do".
Maybe your current code could be changed to clear all the imported files, so that you can re import a new selection.
If that is an option....post the code you already have.
I may not get a look at it tonight, but will be back online tomorrow afternoon.

 

[Michael M]

Glad you got it sorted !!

 

[jabawalkie5000]

Any chance you can help me with my other query in a new thread?

Thanks

Glad you got it sorted !!

 

[Michael M]

Which other query ?
AND
maybe tomorrow....time for bed in OZ !

 

[jabawalkie5000]

http://www.mrexcel.com/forum/showthread.php?t=558262

Which other query ?
AND
maybe tomorrow....time for bed in OZ !