Posts by RossLong

    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