View Full Version : Access VBA to run a macro when cell in excel file is activated


JFKJr
07-23-2008, 10:07 AM
I am having a very tough time working on this, any help/idea on this problem will be greatly appreciated.

Basically, I am looking for an access VBA code, which runs a macro when a cell in excel file is clicked. Thanks a million in advance.

I have searched the internet a lot and lost hope!

boblarson
07-27-2008, 08:59 PM
Can you explain a bit more about what it is that you need to happen and why? I think what you are asking for would require coding in Excel VBA using the Access COM Object model to take care of it, but more info would be good.

JFKJr
07-28-2008, 04:40 AM
Hello boblarson, thanks for the reply.

I am trying to handle excel events through Access VBA and I am able to make the code working by using "WithEvents".

Thanks anyway though :-)