Don't know about recording features in Visual Basic, but there are many applications that can record key strokes, etc. within other applications (e.g., QuicKeys to name just one).
In the long run it may be easier (and cheaper?) to get one of these instead of going with Visual Basic or something else that is internal to Excel.
On a Mac since 1984.
Currently: 24" M1 iMac, M2 Pro Mac mini with 27" BenQ monitor, M2 Macbook Air, MacOS 14.x; iPhones, iPods (yes, still) and iPads.
| 
