VBS Macros

[Victor]

According to a book I recently purchased, when you are entering code to a
macro there is supposed to be a help pop up utility that comes up
automatically to show a list of available properties and methods. For
instance, if you type "application." the pop up utility would display
immediately after you enter the period to show you all of the available
properties and methods for "application". This pop up is not coming up. Is
this feature excluded from Excel:Mac v10? Is there another way to display
the properties and methods?

 

[JE McGimpsey]

According to a book I recently purchased, when you are entering code to a
macro there is supposed to be a help pop up utility that comes up
automatically to show a list of available properties and methods. For
instance, if you type "application." the pop up utility would display
immediately after you enter the period to show you all of the available
properties and methods for "application". This pop up is not coming up. Is
this feature excluded from Excel:Mac v10? Is there another way to display
the properties and methods?

What you're describing is called "intellisense" and is only available in
the Windows VBE. The Mac VBE also lacks the Watch window.

XL/VBA Help lists all the available properties and methods for each
object.

 

[Jim Gordon MVP]

Hi Victor,

Although autocomplete is not available in the Macintosh visual basic editor
there is a work-around.

In the Macintosh version of the visual basic editor you can control-click
any command you type and choose the word "definition" to display the Object
Browser, which describes all of the properties and methods for that command.
In the object browser is a yellow question mark button that will give
further information about the command, including code samples that you can
copy and paste.

Personally, I find the autocomplete feature in the windows visual basic
editor more annoying than helpful so I turn it off.

-Jim