Excel 97 VBA Help File

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

In the MS Excel Visual Basic Reference help file contents page, I click on
Functions and it only offers me functions beginning with the letter S. So, I
have a list of Solver and SQL functions.

But what about all the other functions in VBA, for example for doing
arithmetic and manipulating dates and strings? Why don't they show up?

Are they left out because those functions are all part of Visual Basic
generally, and the Excel VBA help file is specific to the _extra_ functions
in Excel VBA? It's the only explanation I can think of. Am I right, or have
I got a corrupted help file (vbaxl8.hlp)?

It would be really helpful if all the functions were in the same place!

I must say that I am finding VBA to be a ridiculously steep learning curve,
mainly due to the rather poor help files.What I really want is the VBA
equivalent of one of those very basic courses in a foreign language, which
teach you 200 or 300 words of the language - just enough to get by on.
Instead, the help file throws the whole object model at you, without any
indication of what is useful and what is not.

Sorry to rant on so!

Geoff
 
Ken Macksey said:
Hi

I believe that the vba help files are normally not installed with the
default office install. Use your office install cd, run setup and make sure
all of the vba help files are checked and install them.
Yes, I have it installed. and the one on the cd is the same.

As well, here are 2 sites with free tutorials, vb and vba that may help.

http://maths.sci.shu.ac.uk/units/ioa/

and

http://www.tutorialbox.com/

I'll go through these, thanks - they look like what I was after. Thanks very
much.
 
Back
Top