Please help! I'm new to programming Office add-ins, but have been tasked
with creating an Excel add-in that allows the user to apply formats to a
selected range of cells in an open Excel spreadsheet. I've created an VBA
add-in that does the trick, but it has grown too complex to keep as an XLA
and now I'm trying to figure out how to create a standalone add-in that has
the same functionality.

The Question: Is it possible to create a COM (or other compiled) add-in
that applies formats to a selected range in Excel when a certain menu button
is clicked or other event has occurred? If yes, how? Specifically, how do
you tell the add-in which cells to format?

Any help would be appreciated. Apologies for the basic question.

Regards,
Matt