J
Jack Gillis
I originally posted this question in Microsoft.public.excel but have
since found it applies to Word and Access also so I am giving it a try
here.
My OS is WinXP Home and Pro with SP2.
Under Office 2003 Professional Edition with SP1, if I open the VBA
Editor and search for a function (say Msgbox) I get a whole list of
things that can be displayed. All selections respond to a mouse click
and provide a wealth of information except for those noted as (Visual
Basic for Applications.) For those, nothing happens -- the system just
sits there with the mouse cursor changed to a hand.
I have gone to Control Panel/Add Remove Programs and followed the
instructions that appear in several places on the web for adding the
VBA help files. The system reports the update was successful but still
no response to clicking on those items noted as (Visual Basic for
Applications). This happens on my Desktop as well as my Laptop.
Does anyone know what else I might need to do to see the VBA designated
items?
Some additional points came up after I posted the above. When I place
the cursor just before a function, again say msgbox, and press F1 I get
the help I was looking for. When I press F1 for help without the cursor
being near a keyword, I expect to get an Index but I don't. I get the
Assistance pane on the right of the window that gives me the chance to
search -- no index anywhere in sight nor is it there when I open Help
from the menu -- just the search pane.
Maybe I misunderstand what is supposed to happen when I access Help via
F1 or the menu. But I remain puzzled by not getting any result from
clicking on those items which the searched revealed and marked as being
Visual Basic for Applications.
I will appreciate help on this.
Thank you very much.
since found it applies to Word and Access also so I am giving it a try
here.
My OS is WinXP Home and Pro with SP2.
Under Office 2003 Professional Edition with SP1, if I open the VBA
Editor and search for a function (say Msgbox) I get a whole list of
things that can be displayed. All selections respond to a mouse click
and provide a wealth of information except for those noted as (Visual
Basic for Applications.) For those, nothing happens -- the system just
sits there with the mouse cursor changed to a hand.
I have gone to Control Panel/Add Remove Programs and followed the
instructions that appear in several places on the web for adding the
VBA help files. The system reports the update was successful but still
no response to clicking on those items noted as (Visual Basic for
Applications). This happens on my Desktop as well as my Laptop.
Does anyone know what else I might need to do to see the VBA designated
items?
Some additional points came up after I posted the above. When I place
the cursor just before a function, again say msgbox, and press F1 I get
the help I was looking for. When I press F1 for help without the cursor
being near a keyword, I expect to get an Index but I don't. I get the
Assistance pane on the right of the window that gives me the chance to
search -- no index anywhere in sight nor is it there when I open Help
from the menu -- just the search pane.
Maybe I misunderstand what is supposed to happen when I access Help via
F1 or the menu. But I remain puzzled by not getting any result from
clicking on those items which the searched revealed and marked as being
Visual Basic for Applications.
I will appreciate help on this.
Thank you very much.