Excecute Macro if cell changes

[[email protected]]

Hallo Guys,

I have created a new table at runtime and want excecute some code if
the user clicks on a cell. How can I do that?

This doese not work:

Dim oWKS as Worksheet
Set oWKS = ThisWorkbook.Worksheets.Add
oWKS.cells(1,1).onAction = "MyMacro" ' Error

[Don Guillett]

use a worksheet event>right click sheet tab>view code>in left
window>worksheet>select from right window

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> Hallo Guys,
>
> I have created a new table at runtime and want excecute some code if
> the user clicks on a cell. How can I do that?
>
> This doese not work:
>
> Dim oWKS as Worksheet
> Set oWKS = ThisWorkbook.Worksheets.Add
> oWKS.cells(1,1).onAction = "MyMacro" ' Error
>

[[email protected]]

The problem is solved.

Thank you

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> The problem is solved.
>
> Thank you
>