I am brand new to Macros and just need a simple macro that I will run OnActivateSheet that will:
1. Set a Variable: vTest
= if (vBlob = 'test', 'Value1', 'Value2')
2. Select in Field: myFilter
All the example macros are very complex and I am not sure what the minimum is I need to include to just perform the above actions. I had these actions set up individually (without macro), but need to assure that the variable is set before the field is selected.
Re: Basic Macro to Set Variable and Select in Field
You don't need a macro for this and, in fact, I highly recommend avoiding them whenever possible. Go to Settings > Sheet Properties > Triggers < OnActivateSheet > Add Action(s) > Add > External > Set Variable for the first one. Then do the same thing, but select Selection > Select in Field for the second one.