UserForm Error - Exception Occurred

**Aland2929** · 10-02-2011, 09:37 AM

When I open the userform and click on the markup spin button before selecting a customer, I get an "Exception Occurred" error. How do I default to Customer1 when I open the userform without selecting it? I have attached a sample file.
Thank you in advance

**Aland2929** · 10-02-2011, 09:55 AM

On my original workbook, I have to close the userform and then re-open it before the spin button works with the userform displayed?
Thanks in advance

**gjlindn** · 10-02-2011, 10:55 AM

Hi Aland2929. Add this to your form code

Please Login or Register  to view this content.

**Aland2929** · 10-02-2011, 11:17 AM

Thanks for your response. That code selects the first customer name and works perfectly on the test file but when I open the userform for the first time on my actual file, I can't click the spin button until I close the userform and re-open it. Then it works fine? Any ideas why this happens?
Thanks.

**gjlindn** · 10-02-2011, 11:26 AM

You need to set your form's ShowModal property to False.

**Aland2929** · 10-02-2011, 11:26 AM

I found the problem. I updated the code for the userform but did not update the code for the specific sheet - Worksheet_Activate().
Thank you very much for your help. It works perfectly now.