previous code which written in text box

[sterio]

I want Vba code to make last code that I enter in text box appear again something like ctrl+z
Even after I write another code in the text box

[LJMetzger]

Hi sterio,

See the file associated with post #6 in the following thread: http://www.excelforum.com/excel-prog...arameters.html

It uses the little known and sparsely documented .Tag attribute of a UserForm Control, to store the Original Value. When you 'Double Click' a Text Box the value will toggle between the current value and the previous value.

I hope this helps.

Lewis

[Olly]

You can define a class object to store an array of textbox values, which update whenever a new value is entered.

You can then choose to "undo" - revert textbox to a previous value (or even "redo").

Here's the userform module:

Please Login or Register  to view this content.

And the class module:

Please Login or Register  to view this content.

[sterio]

I want code to command button something like below sheet when I hit command button code appear in text box 1

[Olly]

Your requirement is not clear. What exactly are you trying to achieve?

The vba project in your attachment is protected, so I can't see your existing code...

[sterio]

I want when I hit previous code button it make last code whichi wrote in text box 1 appear again