You are welcome! I should explain, since you said you are new at VBA. When a Modal form is shown in Excel, you cannot do anything else in Excel while that form is displayed. But if it is modeless (ShowModal = False) you can continue to do anything else on worksheets or other forms. In more complicated Excel applications these should be managed with great care but your case looks rather simple.