ActiveCell.Value esc or ctl+z

K

KIM W

I have a userform which assigns a value to the active cell using
ActiveCell.Value = variable.
How can I get this edit to the cell to behave as follows (just as if one
typed in values):
1. esc cancels cell entry?
2. ctl+z backs out whatever was just entered in the cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top