Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
jrh jrh is offline
external usenet poster
 
Posts: 14
Default View Modules in VB Editor

In the VB Editor, I have a bunch of modules in my personal
macro workbook listed as module 1, module 2 and so on.
Can I rename these to something more meaningful so I know
which module is which when I am working in the editor?

thank you.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default View Modules in VB Editor

Jrh,

Select (in the project explorer) the module you want to rename. Open (if
not allready open the properties window) and change the name.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"jrh" wrote in message
...
In the VB Editor, I have a bunch of modules in my personal
macro workbook listed as module 1, module 2 and so on.
Can I rename these to something more meaningful so I know
which module is which when I am working in the editor?

thank you.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default View Modules in VB Editor

Hi
try the following
- click on the module in the explorer tree
- hilt F4 (to open the properties dialog)
- change the name

--
Regards
Frank Kabel
Frankfurt, Germany

jrh wrote:
In the VB Editor, I have a bunch of modules in my personal
macro workbook listed as module 1, module 2 and so on.
Can I rename these to something more meaningful so I know
which module is which when I am working in the editor?

thank you.

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
Class Modules vs Modules Jeff Marshall Excel Programming 2 September 28th 03 07:57 PM
Naming Modules Leonard[_2_] Excel Programming 2 July 27th 03 09:03 PM


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