ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Module Numbering (https://www.excelbanter.com/excel-programming/362440-module-numbering.html)

BEEJAY

Module Numbering
 
Greetings:
When setting up numerous modules I like to have them numbered so that all
like info is in the same "grouping"; ie: group 1 (1 thru 19) is all custom
menu Stuff)
group 2 (2 thru 29) is all print stuff; etc................

Is there a way to manually control the numbering of modules?
I just started a file "template" called module numbering with 99 empty
modules in it. This allows me to copy what ever number module I want into my
current project.

I'm hoping there is a better way. There usually is.


Chip Pearson

Module Numbering
 
In the VBA Editor, open the Project Explorer window (CTRL+R),
click on the module and press F4. In this properties window, you
can change the module name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BEEJAY" wrote in message
...
Greetings:
When setting up numerous modules I like to have them numbered
so that all
like info is in the same "grouping"; ie: group 1 (1 thru 19)
is all custom
menu Stuff)
group 2 (2 thru 29) is all print stuff; etc................

Is there a way to manually control the numbering of modules?
I just started a file "template" called module numbering with
99 empty
modules in it. This allows me to copy what ever number module
I want into my
current project.

I'm hoping there is a better way. There usually is.





All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com