Maybe you could use one of excel's events--worksheet_calculate or
worksheet_change might be useful.

You can read more about events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm


Doseeson wrote:

I want to call a piece of code from VB while I'm in Excel, but here's the
tricky part, I don't want to use buttons or any graphical interface. I just
want to be able to call the functionality of a piece of code from a cell with
just formulas.

Something like "=abc()" to run the code in method "abc"

Is that possible?

Thanks,

--

Dave Peterson