MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA libraries?

  Asked By: Ketan    Date: Jan 18    Category: MS Office    Views: 23234

Are there publicly available VBA code libraries?

It seems that whenever I want to do something relatively common but
slightly complex, like return the address of the max value in a range,
I have to rewrite what other people have probably written a million

Is there some repository where useful code scraps are catalogued?



3 Answers Found

Answer #1    Answered By: Sairah Hashmi     Answered On: Jan 18

The Internet is that repository, isn't it? I usually just use Google
to search for what I want, then customize the code  and put it into my
standard add-in for any future use.

For example, I just searched Google for:

vba max  value address

Found quite a few examples of straight-forward formulas, not even
requiring VBA. However, this web page had both:


Answer #2    Answered By: Rosa Reynolds     Answered On: Jan 18

I've downloaded sets of code  examples and even BOUGHT CD's of them.
But in the end, it has been quicker to use the internet and groups
like this one.

The sets of code and the CD's usually are not indexed well enough to
easily find what I need. Plus, If you're wanting something "like"
what the example has, but slightly different. You can't get help
from a CD!

90% of the help I needed I've found in Excel's VBA Help. However,
I've been lucky enough to write code in 6-8 different languages, so
I kind-of know what I'm looking for and what different languages
call it. (There's a whole series of string functions in "C" that are
similar to the InStr function in VBA)

So, my suggestion? Keep coming to us!
You'll find all KINDS of things you never knew you wanted to know!

Answer #3    Answered By: Geldefsman Bakker     Answered On: Jan 18
Didn't find what you were looking for? Find more on VBA libraries? Or get search suggestion and latest updates.