ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   No VBA help for Worksheetfunctions available (https://www.excelbanter.com/excel-worksheet-functions/9510-no-vba-help-worksheetfunctions-available.html)

Toppers

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?

JulieD

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?




Toppers

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?





JulieD

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?







Tushar Mehta

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?







All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com