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

calling procedure
 

Hi Juggernath,

Try something like:

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


---
Regards,
Norman


"Juggernath" wrote in message
...
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...

calling procedure
 

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" wrote in message
...
Hi Juggernath,

Try something like:

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


---
Regards,
Norman


"Juggernath" wrote in message
...
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...

calling procedure
 

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" wrote in message
...
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" wrote in message
...
Hi Juggernath,

Try something like:

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


---
Regards,
Norman


"Juggernath" wrote in message
...
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...