After some internet searching I found that the following statement immediately after Form.show will switch the focus from the userform back to Excel and accomplish exactly what I wanted:

Code:
AppActivate ("Microsoft Excel")