calling procedure

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...

Hi Juggernath,

Try something like:

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


---
Regards,
Norman


"Juggernath" <dvulinsp@mrgn.hr> wrote in message
news:dnmcu7$7gc$1@bagan.srce.hr...
>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...
>

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" <normanjones@whereforartthou.com> wrote in message
news:e4aak59$FHA.228@TK2MSFTNGP12.phx.gbl...
> Hi Juggernath,
>
> Try something like:
>
> '=============>>
> Private Sub Worksheet_BeforeDoubleClick _
> (ByVal Target As Range, Cancel As Boolean)
> Call myMacro
> End Sub
> '<<=============
>
>
> ---
> Regards,
> Norman
>
>
> "Juggernath" <dvulinsp@mrgn.hr> wrote in message
> news:dnmcu7$7gc$1@bagan.srce.hr...
>>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...
>>
>
>

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.


---
Regards,
Norman



"Juggernath" <dvulinsp@mrgn.hr> wrote in message
news:dnmf0v$29j$1@bagan.srce.hr...
> 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" <normanjones@whereforartthou.com> wrote in message
> news:e4aak59$FHA.228@TK2MSFTNGP12.phx.gbl...
>> Hi Juggernath,
>>
>> Try something like:
>>
>> '=============>>
>> Private Sub Worksheet_BeforeDoubleClick _
>> (ByVal Target As Range, Cancel As Boolean)
>> Call myMacro
>> End Sub
>> '<<=============
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>> "Juggernath" <dvulinsp@mrgn.hr> wrote in message
>> news:dnmcu7$7gc$1@bagan.srce.hr...
>>>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...
>>>
>>
>>
>
>