Excel 2003 - VBA - Module Name

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

Is there a way to change the name of the Modules. Mine automatically simply
Module 1, 2 etc. I would like to attach a more descriptive name to the
modules for the future when I come back and do updates.

Craig
 
C Brandt

Select your module, goto>Properties>(Name) change the name to "YourNewName"
Spaces are not allowed!!!!

Mike Rogers
 
In the VBE - Click on the Module1 folder - then in the Properties Pane (View
Properties) Click in Alphabetic tab - (Name) the box to the right where you
see Module1 and CHANGE There !!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Modules 8
Excel 2003 - VBA to get a list of Module names in the project 4
Excel 2007 Crashes when Saving to .xls 2
Excel 2007 Crashes 2
Can a Macro override sheet Protection? 6
UDF in module of personal.xls 3
Copy vb module in all excel sheets 1
VBA Macro to replace VBA module within outlook 1

Back
Top