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.

  • Just found out if I changed this from a worksheet_selection change to worksheet_change event it works perfectly! If only everything in life was so easy. Thank you for the suggestions though. Appreciate it.