Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2014, 07:51 AM
fishhead202 fishhead202 is offline Just Starting Out, Pretty Basic Question Windows 7 64bit Just Starting Out, Pretty Basic Question Office 2010 64bit
Novice
Just Starting Out, Pretty Basic Question
 
Join Date: Oct 2014
Posts: 2
fishhead202 is on a distinguished road
Default Just Starting Out, Pretty Basic Question

I've finally begun playing with macros, mostly find/replace and formatting.

My question is:
I have a handful of different macros now. When I go in to edit any of them, the code from ALL of them appears. Have I set something up wrong, or is this just how it's always listed? It just seems....unwieldy, and if there's something wrong, I'd rather cut it off now rather than after I've added several more.

Appreciate the advice!
Reply With Quote
  #2  
Old 10-30-2014, 12:56 PM
gmaxey gmaxey is offline Just Starting Out, Pretty Basic Question Windows 7 32bit Just Starting Out, Pretty Basic Question Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,428
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

It sounds like you have written all of your procedures in the same module (perhaps the ThisDocument Module). When you open the VB Editor, if not displayed, display the Project Explorer pane (Veiw>Project Explorer). You can organize your macros in named standard modules simply by using Insert>Module. User the Properties pane to give meaningful names to your standard modules.


There are some illustrations here that may help: http://gregmaxey.com/word_tip_pages/...ng_macros.html
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 10-31-2014, 07:35 AM
fishhead202 fishhead202 is offline Just Starting Out, Pretty Basic Question Windows 7 64bit Just Starting Out, Pretty Basic Question Office 2010 64bit
Novice
Just Starting Out, Pretty Basic Question
 
Join Date: Oct 2014
Posts: 2
fishhead202 is on a distinguished road
Default

Thank You!

That link looks especially helpful!
Reply With Quote
  #4  
Old 10-31-2014, 05:56 PM
fumei fumei is offline Just Starting Out, Pretty Basic Question Windows 7 64bit Just Starting Out, Pretty Basic Question Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

It is quite common to have multiple (read many) Subs in any given module. One thing that may help is the two icon buttons at the lower left of the code window.

The default button has FIVE lines (long, short, long, short, long). This displays all of the Subs in the module.

The other has THREE lines (long, short, long). This displays only the Sub the cursor is in.

It is a fast easy way to work on only the Sub you want to work on.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
basic navigation george dyke Word 2 06-19-2014 03:26 PM
Just Starting Out, Pretty Basic Question Need some basic help please!!! jonatob Office 1 11-30-2011 05:14 AM
Forms: A very basic question/request Coli Outlook 0 08-24-2011 11:14 AM
A basic question I'm sure. talosian PowerPoint 0 04-21-2011 05:43 AM
Just Starting Out, Pretty Basic Question Word Basic 2003 to Word Basic 2007 Incompatibility Mark1110 Word VBA 1 12-29-2010 11:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft