Can I display an error message if a cell is left blank AFTER I tab out of/skip over the cell without entering anything? 2nd Question Below!!!

  • Currently my code is throwing a warning message when I click into an empty cell. I need it to display the error box AFTER I go to the next cell, if the previous one was left empty.


    My second issue is my drop down combobox runs off the screen so I can't see the last 2 items on the list, no matter if I select AutoSize property or change the ListRows property. Any help?


    PS I know its messy, I didn't make it, only trying to troubleshoot existing code. I'm very new to VBA. Thanks in advance