Help, excel error 53 (loading userform)

[Kc]

Hi all,

Sorry for my bad englisch.
I wrote a program in Excel that only calls a form to load when in range "C100" the word "Geen" excist.

Private Sub CommandButton9_Click()
If Range("C100").Value = "Geen" Then
MsgBox "Selecteer eerst een poort of en hek, anders werkt het programma niet ;-)"
Exit Sub
End If

Load Maatvoering
Maatvoering.Show
End Sub


The error excel is given me:

Fout 53 tijdens uitvoering
Kan het bestand niet vinden

(Error 53 during execution
File not found)

The userform with the name Maatvoering excist, so that's not the problem.
Can anybody tell me what causes this problem and how to solve it ?


Gerard


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[RB Smissaert]

Is there some code in the UserForm_Activate() or UserForm_Initialize ()
events that may have to do with this?
Put a Stop before Load Maatvoering and step through your code with F8.

RBS

 

[JLGWhiz]

There is nothing wrong with the code you posted. It displayed the userform
for me.
RB is on the right track. The problem lies in another part of your code,
spelling, etc.