formula field can do action

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

VB Code:

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

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

Very small example:

VB Code:

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

Hope this is what you are looking for.

Quote:

---

Originally Posted by Radjesh Klauke[Highlight=VB

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) ?

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. ;)

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