Hi - I am graphing stocks. My charts are basic: O/H/L/C.
My starting point is designated in cell c1. For example, if I want to go back 100 days, I type in -100. If I want to go back 18 days, I type in -18.
In cell c1, is there any way in VBA that I can press the --> or <-- keys (arrow keys) to take me back one day? Instead of typing in -1, then -2, then -3, etc., I can simply press the back arrow key several times...
Thank you.
-Erick
My starting point is designated in cell c1. For example, if I want to go back 100 days, I type in -100. If I want to go back 18 days, I type in -18.
In cell c1, is there any way in VBA that I can press the --> or <-- keys (arrow keys) to take me back one day? Instead of typing in -1, then -2, then -3, etc., I can simply press the back arrow key several times...
Thank you.
-Erick