Excel VBA Help Gripe
Thanks Jim. I used to do what you describe, before a computer reload, but I
guess I'm kind of lazy. I just wander around in '03 Help until I find what
I need, or go to Google Groups.
Doug
"Jim Cone" wrote in message
...
Doug,
If you can get a copy of the Excel 97 help file "Vbaxl8.hlp",
it should work in all later Excel versions. I use it in xl2002.
I agree, it is far superior to the web type interface that MS went to.
It also helps ensure that code used will work in all xl versions.
I call it this way in WindowsXP (with thanks to Chip Pearson)...
Sub ShowVisualBasicHelp()
'The help file for Excel VBA
Shell "c:\Windows\Winhlp32.exe Vbaxl8.hlp", vbNormalFocus
End Sub
Regards,
Jim Cone
San Francisco, USA
"Doug Glancy" wrote in message
...
Keith,
I usually get better results by typing the word, e.g, "range," clicking on
it, and pressing F1. I don't know why the results are different than the,
often irrelevant, results from doing a search in help, but they are.
Maybe
the first is accessing the web and the second isn't?
As an aside, I miss the old "Contents, Index, Find" Help search dialog.
Maybe there's a way to get it back in XL 03 but I haven't stumbled across
it
yet.
hth,
Doug
"keithb" wrote in message
...
Am I the only one having difficulty using Excel VBA help? It would be
ever
so much more useful if documentation for objects, properties, events and
methods were returned in the search listings. As a new user, I did not
know
whether a Range is an Object, Property, or Collection, so I searched for
"Range" which did not return anything useful. As a result I wasted a
long
time before finding Range under Collections.
Keith
|