Module call

[RJH]

Sometimes when I call a routine from a module I can just use the routine
name:
Sub Routine_Clcik()
Routine1
End Sub

Other times I get the error: Compile error, Expected procedure, not variable
and I have to use the module name:
Sub Routine_Click()
[Module1].Rouine1
End Sub

Why is this?

Thanks!
RJH

 

[Bob Phillips]

If the procedure is in a class module associated with one of the worksheets
or the workbook, you have to precede it with the class (module) name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[RJH]

These aren't Class Module calls. They are calls from ordinary modules, for
example: Module1, Module2, etc..

Thanks!

RJH

If the procedure is in a class module associated with one of the
worksheets
or the workbook, you have to precede it with the class (module) name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Sometimes when I call a routine from a module I can just use the routine
name:
Sub Routine_Clcik()
Routine1
End Sub

Other times I get the error: Compile error, Expected procedure, not variable
and I have to use the module name:
Sub Routine_Click()
[Module1].Rouine1
End Sub

Why is this?

Thanks!
RJH

 

[Bob Phillips]

Are you using the same sub name in multiple modules?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

These aren't Class Module calls. They are calls from ordinary modules, for
example: Module1, Module2, etc..

Thanks!

RJH

If the procedure is in a class module associated with one of the
worksheets
or the workbook, you have to precede it with the class (module) name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Sometimes when I call a routine from a module I can just use the routine
name:
Sub Routine_Clcik()
Routine1
End Sub

Other times I get the error: Compile error, Expected procedure, not variable
and I have to use the module name:
Sub Routine_Click()
[Module1].Rouine1
End Sub

Why is this?

Thanks!
RJH

 

[RJH]

No. Unique sub names in each module.

RJH

Are you using the same sub name in multiple modules?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

These aren't Class Module calls. They are calls from ordinary modules, for
example: Module1, Module2, etc..

Thanks!

RJH

If the procedure is in a class module associated with one of the
worksheets
or the workbook, you have to precede it with the class (module) name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Sometimes when I call a routine from a module I can just use the routine
name:
Sub Routine_Clcik()
Routine1
End Sub

Other times I get the error: Compile error, Expected procedure, not
variable
and I have to use the module name:
Sub Routine_Click()
[Module1].Rouine1
End Sub

Why is this?

Thanks!
RJH