Hi,

I can find a lot of information how to autorun macros and subs when opening Excel 2007.

I have one VBA sub "WriteTxt ()" which writes information from excel to text file. It works only when pressing F5 in VBA window.

Is it possible to get it running automatically by entering a value into a cell?