Student or Learner
Developing a macro is communicating with Excel.
We call this Excel VBA which is a kind of programming.
Should I use create, develop or write ?
In my office, I often create, develop / write to reduce the time we needed to spend on Excel sheetwork.
However, I don't think what people will ususally say.
You most commonly hear of people writing macros.