LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I have a gripe... pgarcia Excel Discussion (Misc queries) 3 November 13th 07 05:18 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"