Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Toppers
 
Posts: n/a
Default No VBA help for Worksheetfunctions available

When I use the VBA object browser and select a Worksheetfunction I am unable
to get the corresponding VBA help pages. I am (apparently) directed to the
Internet as I get "The Page cannot be displayed" message.

The normal Excel Help works OK.

I am using Office 2003.

Any suggestions as to why this is?
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

same here, however, i don't use the object browser but i use the "ask a
question" box instead - and if you type "worksheet functions" in there
towards the bottom of the list of returned options is
"List of worksheet functions available to visual basic"
if you choose the function in this list help seems to work fine.

hope this helps
Cheers
JulieD

"Toppers" wrote in message
...
When I use the VBA object browser and select a Worksheetfunction I am
unable
to get the corresponding VBA help pages. I am (apparently) directed to
the
Internet as I get "The Page cannot be displayed" message.

The normal Excel Help works OK.

I am using Office 2003.

Any suggestions as to why this is?



  #3   Report Post  
Toppers
 
Posts: n/a
Default

Julie,
Thanks for your reply. I guess I don't understand why the VBA help
in Object Browser has (apparently) been removed and why it provides a
meaningless "error" message..

John

"JulieD" wrote:

Hi

same here, however, i don't use the object browser but i use the "ask a
question" box instead - and if you type "worksheet functions" in there
towards the bottom of the list of returned options is
"List of worksheet functions available to visual basic"
if you choose the function in this list help seems to work fine.

hope this helps
Cheers
JulieD

"Toppers" wrote in message
...
When I use the VBA object browser and select a Worksheetfunction I am
unable
to get the corresponding VBA help pages. I am (apparently) directed to
the
Internet as I get "The Page cannot be displayed" message.

The normal Excel Help works OK.

I am using Office 2003.

Any suggestions as to why this is?




  #4   Report Post  
JulieD
 
Posts: n/a
Default

Hi John

i guess i've been using MS products for long enough now not even to think
about it :)

Cheers
JulieD



"Toppers" wrote in message
...
Julie,
Thanks for your reply. I guess I don't understand why the VBA help
in Object Browser has (apparently) been removed and why it provides a
meaningless "error" message..

John

"JulieD" wrote:

Hi

same here, however, i don't use the object browser but i use the "ask a
question" box instead - and if you type "worksheet functions" in there
towards the bottom of the list of returned options is
"List of worksheet functions available to visual basic"
if you choose the function in this list help seems to work fine.

hope this helps
Cheers
JulieD

"Toppers" wrote in message
...
When I use the VBA object browser and select a Worksheetfunction I am
unable
to get the corresponding VBA help pages. I am (apparently) directed to
the
Internet as I get "The Page cannot be displayed" message.

The normal Excel Help works OK.

I am using Office 2003.

Any suggestions as to why this is?






  #5   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Worked for me. Opened the object browser, typed in Worksheetfunction
in the search field, got 2 hits in the top pane titled Library, right-
clicked on the first one and selected Help. Also, selected the 2nd one
and used F1 to get to help.

What also worked was selecting Application in the left bottom pane
(labeled Classes), then scrolling to and selecting Worksheetfunction in
the right bottom pane (labeled Members of Application) and pressing F1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Julie,
Thanks for your reply. I guess I don't understand why the VBA help
in Object Browser has (apparently) been removed and why it provides a
meaningless "error" message..

John

"JulieD" wrote:

Hi

same here, however, i don't use the object browser but i use the "ask a
question" box instead - and if you type "worksheet functions" in there
towards the bottom of the list of returned options is
"List of worksheet functions available to visual basic"
if you choose the function in this list help seems to work fine.

hope this helps
Cheers
JulieD

"Toppers" wrote in message
...
When I use the VBA object browser and select a Worksheetfunction I am
unable
to get the corresponding VBA help pages. I am (apparently) directed to
the
Internet as I get "The Page cannot be displayed" message.

The normal Excel Help works OK.

I am using Office 2003.

Any suggestions as to why this is?





Reply
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



All times are GMT +1. The time now is 10:32 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"