Ok, so I'm a newbie at VBA. Here is what I want to be able to do:
I have a cell connected to either a drop-down button or perhaps a formula (not sure if it matters that the cell changes based on a button or a formula, but I'm putting that in just in case).
What I would like to have happen is that a macro runs based on the contents of that cell.
For example, if the contents of cell "A1" change to a 5, I might want to change to full screen mode. If "A1" changes to a 6, I might want a UserForm to automatically pop-up, etc.
So, I am able to get bits and pieces, but can't get it to work quite right, particularly the part about getting it to run automatically upon a change in the cell. Again, cell A1 might be an IF or OFFSET statement itself.
Thanks in advance & please remember that I know very little about VBA.