ActiveCell.Value esc or ctl+z

KIM W

Guest

Posts: n/a

19th Feb 2009

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?

« analysis toolpak problem | Creating product key »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Last ActiveCell	Steven	Microsoft Excel Programming	9	18th Sep 2008 02:32 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Microsoft Excel Misc	1	2nd Oct 2007 08:05 PM
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format	Karthik Bhat - Bangalore	Microsoft Excel Programming	1	9th May 2007 02:37 PM
IF ACTIVECELL contains	FIRSTROUNDKO via OfficeKB.com	Microsoft Excel Programming	4	3rd May 2006 05:17 PM
how to set activecell?	ljb	Microsoft Excel Programming	2	18th Nov 2003 04:49 PM