View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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...