can a formula field execute a script? or do some action such as making a dialog box note ?
Printable View
can a formula field execute a script? or do some action such as making a dialog box note ?
The result of your formula should be 1 in this case.VB Code:
If Range("A1").value = 1 then 'call action
Very small example:
Hope this is what you are looking for.VB Code:
If range("A1").value = 1 then MessagBox "Range("A1").Value = 1", vbinformation +vbokonly, "Message" End if
where would you write the vbcode in the macro environment(VBA ide) ?Quote:
Originally Posted by Radjesh Klauke[Highlight=VB
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