Compil error Expected variable or procedure not module

[ipbr21054]

Afternoon,

I have a command Button on my worksheet which opens a userform.
When i click the button i see the following Compile error,
Expected variable or procedure not module.

The code on the button is as follows.

Private Sub SearchFormButton_Click()
Call OpenATOZ
End Sub

Is this just not allowed or have i missed something.

Please advise thanks

 

[gordsky]

Afternoon,

I have a command Button on my worksheet which opens a userform.
When i click the button i see the following Compile error,
Expected variable or procedure not module.

The code on the button is as follows.

Private Sub SearchFormButton_Click()
Call OpenATOZ
End Sub

Is this just not allowed or have i missed something.

Please advise thanks

this usually occurs when you have a module and a sub with the same name. Do you have a module called OpenATOZ as well as a sub with same name?

 

[ipbr21054]

Hi,
Ive checked & you are correct.
Now renamed all is ok

Thanks