Is there a specific way or VB code that can run a macro when the cell is deselected?
Im trying to create a historical value within a cell so when someone types in the cell and finishes typing, and the cell is deselected the macro run's and dumps the typed information into another sheet, I need to know how to run it when the cell is deselected
any idea's?
It's not really de-selection rather it is a Change event
(the cell only moves (de-selects) because the options on the client are set to do so... you can configure XL to not move cell on pressing Enter)
If for ex. you wanted to copy A1 when changed to Sheet2 and the next blank row in Column A something like
To insert the above you would right-click on Sheet1 tab in Native XL, select View Code and insert the above into the resulting window at which point when A1 is altered on Sheet1 Column A on Sheet2 is updated with the latest value (a log of sorts)
Please Login or Register to view this content.
(I've not disabled/enabled the events in the above given in this instance the cell being written to is on a different sheet)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks