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,

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

"Ian" wrote:

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,

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

--
Regards,
Tom Ogilvy

"Ian" wrote in message
...
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,

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/SiliconVall...freewheel.html .


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



"Ian" wrote in message
...
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,

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

ThisWorkbook.VBProject.VBComponents("Module1").Cod eModule.Name = "mTest"

--

HTH

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


"Ian" wrote in message
...
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,

Chip,

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

"Chip Pearson" wrote:

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/SiliconVall...freewheel.html .


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



"Ian" wrote in message
...
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,

Thanks to all, problem solved.


"Bob Phillips" wrote:

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

ThisWorkbook.VBProject.VBComponents("Module1").Cod eModule.Name = "mTest"

--

HTH

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


"Ian" wrote in message
...
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,