Hi,
First let me say that I find this forum extremely useful and will troll the message boards if I need help.
I have a workbook with multiple user forms that I have used for about 4 months now. Today, all of a sudden, I can't get one of the forms to show even in a simple procedure. Specifically, I am using this procedure (frmPolicySetting being the name of the form):
Sub Test()
frmPolicySetting.Show
End Sub
When I try to run this procedure, I get a "Run-time error 9: Subscript out of range" error, which baffles me. I've triple-checked the name of the form, so I know it is correct. There are no other workbooks open. This procedure worked yesterday; since then, all I have done is add some additional text boxes to the form. Are there any form settings that could be causing this issue?
Thanks for your help,
Tristan
First let me say that I find this forum extremely useful and will troll the message boards if I need help.
I have a workbook with multiple user forms that I have used for about 4 months now. Today, all of a sudden, I can't get one of the forms to show even in a simple procedure. Specifically, I am using this procedure (frmPolicySetting being the name of the form):
Sub Test()
frmPolicySetting.Show
End Sub
When I try to run this procedure, I get a "Run-time error 9: Subscript out of range" error, which baffles me. I've triple-checked the name of the form, so I know it is correct. There are no other workbooks open. This procedure worked yesterday; since then, all I have done is add some additional text boxes to the form. Are there any form settings that could be causing this issue?
Thanks for your help,
Tristan