Selection Change Event w/Drop Down Selection

  • I am running the following selection change event however it only works AFTER I select a different cell and then re-select the target cell. The target cell had a drop down list for the user to select either dayshift or nightshift. I tried to have it programmatically select a different cell before re-selecting the target however that ended up in an endless loop or sorts. Any ideas on how to get this to work immediately after the user make a selection?

  • Unfortunately, I can use the worksheet change/calculate events because there will be other instances of these cells being zero throughout the day. It can only happen immediately after the user chooses either dayshift or nightshift.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!