Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Renaming VBA Modules

Hello

In Project Explorer view in the VBA window, I have seven Modules of code.
Often when I am looking for a specific procudure it is difficult to find
because I cannot figure out how to ReName the Modules.

Does anyine know how I can rename the Modules from Module1, Module2... etc
to (text) names that are more cognitive.

Thank you in advance.

W


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Renaming VBA Modules

Hi
in the VBA editor try the following:
- select the module
- hit F4
- change the module name

--
Regards
Frank Kabel
Frankfurt, Germany

"cogent" schrieb im Newsbeitrag
...
Hello

In Project Explorer view in the VBA window, I have seven Modules of

code.
Often when I am looking for a specific procudure it is difficult to

find
because I cannot figure out how to ReName the Modules.

Does anyine know how I can rename the Modules from Module1,

Module2... etc
to (text) names that are more cognitive.

Thank you in advance.

W



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Renaming VBA Modules

In the VBE, in the Project Explorer window (Ctrl-R), select the module you
want to rename, then goto the Properties window (F4), and you will see the
name property there. Just over-type it.

--

HTH

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

"cogent" wrote in message
...
Hello

In Project Explorer view in the VBA window, I have seven Modules of code.
Often when I am looking for a specific procudure it is difficult to find
because I cannot figure out how to ReName the Modules.

Does anyine know how I can rename the Modules from Module1, Module2... etc
to (text) names that are more cognitive.

Thank you in advance.

W




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
VB Modules dhstein Excel Discussion (Misc queries) 9 November 8th 08 09:46 PM
Help with modules. Cloudy New Users to Excel 1 June 17th 08 10:10 AM
modules libby Excel Programming 4 November 22nd 03 01:34 PM
Forms and Modules scrabtree23[_2_] Excel Programming 4 November 11th 03 03:57 PM
Class Modules vs Modules Jeff Marshall Excel Programming 2 September 28th 03 07:57 PM


All times are GMT +1. The time now is 10:23 AM.

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"