Excel VBA – Get or Display Current Cell Position (Coordinates)?
To display the currently selected cell’s position in a msgBox:
Excel VBA - To Get / Control the Currently Selected cell object?
As a related option: to get / control the currently selected cell as an object:
Then, you could access the selected cell as an object and edit it’s characteristics as you would any other Excel range object.