VBA - code snippets collected over 25+ years

User avatar
Charles Kenyon
5StarLounger
Posts: 673
Joined: 10 Jan 2016, 15:56
Location: Madison, Wisconsin

VBA - code snippets collected over 25+ years

Post by Charles Kenyon »

Because of the vba interest in this forum I am cross-posting, sort-of.
I just posted an article with a listing of hundreds of macros on the Word Answers Forum.

Some may not work, a few only apply to menu versions of word, like animated text.
The article is a listing of macro names with some description together with a link to .bas and .txt listings of the module.
Some of them come from this forum. It includes multiples of Doug Robbins' FixIt macro for black boxes in multilevel list numbering.

Here is a link to the article, which contains a link to the module listing.
https://answers.microsoft.com/en-us/mso ... 5249625394

User avatar
HansV
Administrator
Posts: 79952
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA - code snippets collected over 25+ years

Post by HansV »

Thanks, Charles!
Best wishes,
Hans

PJ_in_FL
5StarLounger
Posts: 1165
Joined: 21 Jan 2011, 16:51
Location: Florida

Re: VBA - code snippets collected over 25+ years

Post by PJ_in_FL »

Would love to see the snippets HansV has made over the years for Excel. Feeling generous?
PJ in (usually sunny) FL

User avatar
HansV
Administrator
Posts: 79952
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA - code snippets collected over 25+ years

Post by HansV »

There are so many of them...
Best wishes,
Hans

User avatar
Charles Kenyon
5StarLounger
Posts: 673
Joined: 10 Jan 2016, 15:56
Location: Madison, Wisconsin

Re: VBA - code snippets collected over 25+ years

Post by Charles Kenyon »

And that is just one module - my catch-all module. I have more than 50 modules!
Again, I gathered these as samples of coding that I wrote or found. Most are set to not show up in my macros list!