calling procedure

[Juggernath]

I have event procedure (click) in a worksheet (vba space) and trying to call
a procedure in a module from a event procedure. I think I do not know
exactly syntax for that...

 

[Norman Jones]

Hi Juggernath,

Try something like:

'=============>>
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Call myMacro
End Sub
'<<=============

 

[Juggernath]

It was very stupid question, sorry.
The problem was the procedure has the same name as the module (ZFAK)
So i have to callit like this: call ZFAK.ZFAK
Thanx, and sorry everbody

 

[Norman Jones]

Hi Juggernath,

You should avoid naming a macro and a module with the same name as this will
cause problems. You should rename the module or the procedure.