• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vba snippets

M

Malcolm

New Member
Hi everyone,
I have been looking for basic VBA snippets that I could keep for reference and alter when needed. I am currently trying to learn VBA and still a beginner/intermediate so need basic snippets that I could use.
Does anyone have a large collection of sample macros or are there any good resources on the internet anyone knows of?
 
Hi, Malcom!

Active member jeffreyweir has just published an excellent article at this website, in case you're not subscribed to the newsletter (which I recommend you) this is the link:
http://chandoo.org/wp/2013/11/02/what-would-james-bond-have-in-his-personal-macro-workbook/

If you want to read the topic started here before that article edition, here's the link:
http://chandoo.org/forum/threads/wh...-made-multiple-use-macros-from-the-web.13013/
My humble contribution at this post, which I think it's related to your question:
http://chandoo.org/forum/threads/wh...ple-use-macros-from-the-web.13013/#post-76626

You won't find there directly the VBA snippets that you're looking for, but you'll get what's even most important: their sources. So besides the selected snippets that you may choose, you'll be invited/incited to dig deeply into each linked page... and there another world will be opened at each one.

Regards!
 
Hi Smallman,
Thanks for your response. I'm looking for basic codes for lookups, loops and formatting. Just looking for simple snippets that I can amend to increase my knowledge and apply it in my job.
 
Hi, Malcom!
Glad to help you, and don't forget using the built-in recorder macro feature describe in jeffreyweir's article. Get used to it and your learning process will be fastened.
Regards!
 
I think Jeff must have pulled the page as the link and a google search for the James Bond themed article seem show that the article has gone MIA.

Malcom you will find what you are looking for and more from the suggested sites and if you don't just come on here and ask there are plenty of XLers on here with very high skill levels who can help.

Take care

Smallman
 
You must log in or register to reply here.
Back
Top