Create a VBA macro that insert/append HTML tag upon highlight of selection

[psydere]

Hello! I have a some words that I want to be surrounded by <code> </code> tags in my Excel cells, however, I want it to be done without using formula because there is a lot of them and formula is not context sensitive so I want to opt for macro due to its versatility. How do I get it done? (Yes, this is done manually)

Sample text: Select the AddTotal macro that you just recorded.

I then use Macro shortcut to activate macro.

Then highlight(select) that specific text. Which in this case is AddTotal

Then get this output: Select the <code>AddTotal</code> macro that you just recorded.