Object required when object exists

[Danni317]

Hi All,

I have this code:
Public Function WhichForm(ByVal NofT As Integer)

Select Case NofT
Case 1 To 6
' Display the corresponding form based on NofT
Select Case NofT
Case 1
formTanker1.Show
Case 2
formTanker2.Show
Case 3
formTanker3.Show
Case 4
formTanker4.Show
Case 5
formTanker5.Show
Case 6
formTanker6.Show
End Select

End Select

End Function

It is finding the correct form however, it is saying that the formTanker# object is required, even though it does exist.

Any ideas?

 

[RoryA]

It may be an error in the Userform_Initialize or Userform_Activate codes in the userform(s). When the error occurs, press Debug, then press f8 to step through the code until you get to the real error.

 

[eiloken]

Hi All,

I have this code:
Public Function WhichForm(ByVal NofT As Integer)

Select Case NofT
Case 1 To 6
' Display the corresponding form based on NofT
Select Case NofT
Case 1
formTanker1.Show
Case 2
formTanker2.Show
Case 3
formTanker3.Show
Case 4
formTanker4.Show
Case 5
formTanker5.Show
Case 6
formTanker6.Show
End Select

End Select

End Function

It is finding the correct form however, it is saying that the formTanker# object is required, even though it does exist.

Any ideas?

it worked for me