Rename Modules

[Guest]

I am working on a VBA project adding Modules and UserForms, but I can't seem
to rename either of these. I have seen samples which have different, more
meaningful names. There doesn't seem to be a simple right-click option,
please help. Also, does anyone know how to activate the mouse wheel to scroll
up and down in the code window? Being so used to using it everywhere else it
is frustrating not to be able to use it in this instance.

Thanks for your help,

 

[Guest]

ian,
open your properties window. (where you edit userform controls information)
and then select a module. There is only one option to edit on a module- The
name
ben

 

[Tom Ogilvy]

when the module or form is selected, look in the properties window. You can
rename it there.

 

[Chip Pearson]

Ian,

In the VBA editor, press F4 to display the properties menu.
Change the name of the module there.

The latest MS mouse drivers (Intellimouse 5) don't allow mouse
wheel scrolling in the VBA editor. Use an earlier version
(version 4), or download and use FreeWheel
http://www.geocities.com/SiliconValley/2060/freewheel.html .


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

 

[Bob Phillips]

Using VBA, in a mcro, or in the immediate window

ThisWorkbook.VBProject.VBComponents("Module1").CodeModule.Name = "mTest"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Chip,

Much thanks for that link to freewheel, not being able to scroll in VBA was
driving me batty.
ben

 

[Guest]

Thanks to all, problem solved.

Using VBA, in a mcro, or in the immediate window

ThisWorkbook.VBProject.VBComponents("Module1").CodeModule.Name = "mTest"

--

HTH

RP
(remove nothere from the email address if mailing direct)