Hi Adam,
Sorry for the delay. The CurrentCellValidating event will be triggered only if the user leaves the cell. Here is a sample which, uses the CurrentCellKeyPress event to toggle between the values in the dropdown when the space bar is pressed.
Sample :
ToggleSelection_ComboBox
Thanks for being patient.
Best regards,
Madhan