| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change event question
On Tue, 1 Mar 2016 13:34:18 +0100, Claus Busch
wrote: Hi Frank, Am Tue, 01 Mar 2016 07:31:43 -0500 schrieb Phrank: The problem is the worksheet change event sees the 'ActiveCell' as the cell to the right or below the cell where the number was entered. don't work with ActiveCell. Work with Target. Target is the cell that has been changed. Regards Claus B. Hi again. Just wanted to follow up. That was so brilliantly simple. I'm all set now. Thank you! Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quick VBA Worksheet Change Event or Selection Question: | Excel Worksheet Functions | |||
| Worksheet Change Event question | Excel Programming | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Threaded Mode
