formula field can do action

[rwin]

can a formula field execute a script? or do some action such as making a dialog box note ?

[Radjesh Klauke]

If Range("A1").value = 1 then 'call action

The result of your formula should be 1 in this case.

Very small example:

If range("A1").value = 1 then
   MessagBox "Range("A1").Value = 1", vbinformation +vbokonly, "Message"
End if

Hope this is what you are looking for.

[rwin]

If range("A1").value = 1 then
MessagBox "Range("A1").Value = 1", vbinformation +vbokonly, "Message"
End if[/Highlight]

where would you write the vbcode in the macro environment(VBA ide) ?

[Radjesh Klauke]

The page where you want to execute the code. If the formula is in page one place the code in the IDE also on page one.

[zaza]

Also be aware that each worksheet has a Worksheet_Change event which fires every time a cell is changed. This event returns a range named Target to tell you which range was changed, so you can use this to trap changes in cells and cause code to action accordingly.

zaza