How do I call a method in VB from Excel with JUST code?

[Guest]

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,

 

[Bob Phillips]

If the latter, it can only return a value, not manipulate the cell or the
sheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

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