Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Look up VBA documentation using Excel Help

I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Look up VBA documentation using Excel Help

Wellie,

The problem with the object browser is that you have to have a fair
understanding of the object model to use it effectively.

For instance, Cells is a range, so you have to look up Range in the OB not
Cells( obvious eh?<g), and look for the Find property within the Range
object. This will then give you a description of the Find method.

VBA Help is a better tool for this, you can loo Find and Cells within there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Wellie" wrote in message
...
I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default Look up VBA documentation using Excel Help

In the codepane click the mouse on the word ".Find"

Then press the F1 key. The context sensitive help usually works fairly well.

Troy

"Wellie" wrote in message
...
I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel 11.0 Object Library documentation? Just-a-COG-in-the-works Charts and Charting in Excel 0 April 25th 07 05:22 PM
Documentation 4 Excel Web Component Marek Excel Programming 0 April 14th 04 08:31 AM
Documentation Mark[_36_] Excel Programming 4 February 5th 04 11:02 AM
Excel Format documentation Oleg Fedtchenko Excel Programming 4 January 21st 04 02:50 AM
Excel Object Documentation Chris Excel Programming 1 January 16th 04 04:13 AM


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