Sorry, this should have been OnEntry rather than OnChange.

Sub StartOnChange()
Worksheets("Sheet2").OnEntry = "MyMacro"
End Sub

Or perhaps you were talking about the Change Event, a sheet level event.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
did you run a macro like

Sub StartOnChange()
Worksheets("Sheet2").OnChange = "MyMacro"
End Sub

--
Regards,
Tom Ogilvy

"hshayh0rn" wrote in message
...
From the last time I posted I found the on change event and thought that
might be the answer but the code Bob supplied does not work when I add
it
to
the on change event.

"Jim Thomlinson" wrote:

That is an on demand macro that the user would have to run on their
own.
You
could use the On Change event from Sheet 2 if you needed it to be
automatic.
--
HTH...

Jim Thomlinson


"hshayh0rn" wrote:

Thanks for the reply... So, would the user have to run the macro
manually or
does excel know to run this on its own?

"Bob Phillips" wrote:

Sub myMacro()
If Worksheet("Sheet2").cells(12,3) = "N" Then
Worksheet("Sheet3").cells(3,2) = "Sold Out"
ElseIf Worksheet("Sheet2").cells(12,3) = "Y" Then
Worksheet("Sheet3").Visible = False
End If
End Sub

This would be an on-demand macro, stored in a standard code
module.

--

HTH

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


"hshayh0rn" wrote in message
...
I have a very basic question but I can't seem to find the answer
on here
(probably to basic). I have a spreadsheet that I would like to
perform all
of
my calculations / If / Then statements using VBA but I'm not
sure
how to
actually get the code to run or where to put it to run... I can
get all of
the code to run with an on click event or something like that
but
basically
I'd like cells to automatically fill in other cells based on
values the
users
put in them. For example:

If sheet2!.cells(12,3) = "N" Then

Sheet3!.cells(3,2) = "Sold Out"

or

If sheet2!.cells(12,3) = "Y" Then

Sheet3!.Visible = False

I'll keep searching for the answers to this question but if
someone could
shoot me a quick answer I would appreciate it.