Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Word / October 2005



Tip: Looking for answers? Try searching our database.

Mapping Visual Basic

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tim - 11 Oct 2005 20:50 GMT
I am looking for an article on the basic layout of VBA. Maybe a map
would work. More specifically, when you edit a macro, there are 3
panels that open. The Projects, Properties, and the panel that says
Normal-NewMacros (code). The third one I have a handle on but the
Projects one is what I am trying to figure out. Finally, what are the
form, modules, and class modules for under "The Projects" panel?
Daiya Mitchell - 11 Oct 2005 22:34 GMT
You can see #3 here, which offers a little (I can't tell if you are already
beyond that level):
http://word.mvps.org/MacWordNew/InstallMacroMac.htm
(hit refresh a few times in Safari, or use a different browser)

And somebody else will likely be along with a more sophisticated
explanation, as I am pretty much a VB novice. Basically, macros are stored
in modules, and modules are stored in documents or templates.  For some
reason the VB Editor refers to documents/templates as Projects (actually,
documents seem to be Projects and templates are TemplateProjects).

Forms/Class Modules I am not familiar with and have never needed to
investigate, but they are created via the Insert menu and appear to have a
similar purpose to regular modules.  For instance, I don't have any Forms or
Class Modules because I have never inserted any--the default setting is just
for Normal to have one NewMacros module, as far as I know.

> I am looking for an article on the basic layout of VBA. Maybe a map
> would work. More specifically, when you edit a macro, there are 3
> panels that open. The Projects, Properties, and the panel that says
> Normal-NewMacros (code). The third one I have a handle on but the
> Projects one is what I am trying to figure out. Finally, what are the
> form, modules, and class modules for under "The Projects" panel?

Signature

Daiya Mitchell, MVP Mac/Word
Word FAQ: http://www.word.mvps.org/
MacWord Tips: <http://www.word.mvps.org/MacWordNew/>
What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/

JE McGimpsey - 12 Oct 2005 18:30 GMT
> I am looking for an article on the basic layout of VBA. Maybe a map
> would work. More specifically, when you edit a macro, there are 3
> panels that open. The Projects, Properties, and the panel that says
> Normal-NewMacros (code). The third one I have a handle on but the
> Projects one is what I am trying to figure out. Finally, what are the
> form, modules, and class modules for under "The Projects" panel?

This link may help (it applies to XL/VBA, but for most of your purposes,
the information is transferable):

   http://www.mcgimpsey.com/excel/modules.html

Projects are the Visual Basic term that includes VB modules (regular
code modules, user forms, class modules) and documents/templates
associated with applications (e.g., Word).

Each Project will have at least a Document and Document-level class
module. If you add regular code module(s) or userform(s), the project
will contain those as well.

You use the Projects window to select which project/module you're
working on. By default, your code is added to a regular code module in
the Normal template (the Normal-NewMacros module). Macros in a template
are available to all documents that have that template attached. You can
also attach a module to a document, so that it's available only when
that document is open.

The Properties window is used to display/set the properties of the
selected object. When a module is selected, the module's properties are
selected. If a userform is selected, the properties window will show the
userform or component properties (i.e., button color, text, size, etc.).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.