I'm going to be using Excel to take notes, so I'm attempting to make it easy to add bullet points.
I have code that adds a bullet point if the cell's blank, and creates a new line and adds a bullet point if there's already a value.
Right now though, I'm having to hit Enter (which takes me down a cell), press shortcut to run macro, then press up to go back to the cell and hit F2 to go into the cell.
So, I have a few questions:
1. Is it possible to run a macro while within a cell? (Typing in a cell prior to hitting enter)
2. Is there a shortcut that accepts the value (like Enter) but doesn't move to a different cell?
3. Is there a way in VBA to do the equivalent of the F2 shortcut?
Bookmarks