spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- Windows
I have an excel workbook with macros
The following code appears in This Workbook
Worksheets("Geometry (mm)").OnEntry = "Every_Update"
Every_Update is a macro that calls other macros to run every time The worksheet Geometry (mm) has an entry
This has been working well for some time
Today i added a cell with a drop down list in the worksheet Geometry (mm)
I am finding that when i select from the drop down list in cell C12, the macro Every_Update does not run. I need it to run
I am guessing the reason is that entry is not pressed once the drop down list item is selected
How can i get Every_update to run when selecting from a drop down list?
The following code appears in This Workbook
Worksheets("Geometry (mm)").OnEntry = "Every_Update"
Every_Update is a macro that calls other macros to run every time The worksheet Geometry (mm) has an entry
This has been working well for some time
Today i added a cell with a drop down list in the worksheet Geometry (mm)
I am finding that when i select from the drop down list in cell C12, the macro Every_Update does not run. I need it to run
I am guessing the reason is that entry is not pressed once the drop down list item is selected
How can i get Every_update to run when selecting from a drop down list?