Re: Running a Sub from a cell expression in Excel

In article <fcd73288-6ef2-4878-85ce-dd52c857daee@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
David K. wrote:
On 15 ×?צ×?×?ר, 22:59, Steve Rindsberg <ab...@xxxxxxxxxxxxx> wrote:
In article <84f316e3-fd70-4398-9277-ca5041ac0...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,

David K. wrote:
I am new to VBA. I wrote a simple Sub in VBA (say MySub). When I try
to run it from a cell expression in Excel (=MySub), I get the
following message:  "That name is not valid".
Any help will be appreciated.

I think you need a function rather than a sub (sub doesn't return a value, a
function does)

Example:  this in a cell:

=GimmeFive()

Invokes this:

Function GimmeFive() As Integer
    GimmeFive = 5
End Function

I'm a PowerPointPusher.  There's probably lots more to this I haven't a clue
about, but this might be enough to get you going.

--
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================

Steve,

Thank you for your help.
Yes, I know that a function returns a value. Yet, Sub is what I need,
since it performs some procedure. for example: Say my Sub displays
some message.
My question still stands; How do I run a Sub from within an Excel
cell.

I suspect you can't. I'm probably wrong about this, but I'm assuming Excel wants
the called code to return a value to plug into the cell.

If your cell references a function, the function could call a sub, though, no?

The function (and hence the sub) would be called whenever the *** recalculates,
I'd guess.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


.

Loading