How to run 2 CreateEventProc modules on 2 sheets simultaneously
Can we see the code?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"noname" wrote in message
ups.com...
Workcode1 and Workcode are 2 diff modules which have the
CreateEventProc 's for each Sheets... say Sheet1 and Sheet2.
rgds,
On Oct 23, 12:48 pm, "Bob Phillips" wrote:
What is in WorkCode1 and 2?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"noname" wrote in message
ups.com...
Hi,
I have 2 code modules (Workcode1 n Workcode2) which have VBA code for
CreateEventProc to enter them into 2 sheets say Sheet1 n Sheet2.
i m calling them from a single module called Doit() like this:
Sub Doit()
Sheets("Sheet1").Activate
Call Workcode1
Sheets("Sheet2").Activate
Call Workcode2
End Sub
giving me Runtime error 9, subscript out of Range. I see that only
workcode1 gets added to sheet1 and not workcode2 to sheet2.
if i do the vice-versa, i see that it only adds 1 module either
workcode1 or workcode2....so i have come to the conclusion that it
does not allow 2 CreateEventProc 2 run 1 after the other....it CRASHES
EXCEL.
How do i go about rectifying this now....Any suggestions r most
welcome..
Regards
|