MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

"Microsoft Visual Basic Help" in Excel 2007

  Asked By: Sienna    Date: Feb 17    Category: MS Office    Views: 1103

I am alone in finding the "Microsoft Visual Basic Help" in Excel 2007
to be rather hopeless and worse than Excel 2003? I particularly miss
the "See also" links that used to exist.

Also, whilst exploring the datediff() function that was mentioned in
this group last week, I found that entering "datediff" (with 2 "f"s) as
a search term returned no results, whereas entering "datedif" (with
1 "f") gave one result: the "DateDiff" function (with 2 "f"s)!

What do other Excel 2007 users on this group use as a reference guide
to functions, etc?



1 Answer Found

Answer #1    Answered By: Marta Kim     Answered On: Feb 17

I keep a 3-ring binder as a journal of code snippets & interesting function
solutions from past projects. I 'log' the date in the upper right page corner
then give it a functional 'category' it relates to. A spreadsheet is kept by
sorting on the category then sorting by date. Pretty easy to find related info
pretty fast.

Didn't find what you were looking for? Find more on "Microsoft Visual Basic Help" in Excel 2007 Or get search suggestion and latest updates.