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.