Rather low-tech I know but I have a text file with common tags, etc for when I upload photos or videos to Flickr or youtube.
Just keep it open then cut & paste. Not as convenient as macros but it works.
I used to use the macros in Excel many years ago but most of the functions were phased out when MS started pushing VisualBasic.
Not all changes are improvements.