Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Rename VBA Module1? 1

Status
Not open for further replies.

VBAjedi

Programmer
Dec 12, 2002
1,197
KH
Quick question: what's the fastest way to rename a module from the default Module1, Module2, etc? I want to name it something more descriptive ("StartUpRoutines", etc).

I tried exporting the module (typing in a new name as I did so) and importing the same module, but it just had a new default name assigned to it (Module11).

Thanks!
VBAjedi [swords]
 
Select the module in the project explorer (top left window in VBE), and modify the name property in the property window below it.
Rob
[flowerface]
 
D'oh! I KNEW the answer would make me look stupid! (although it wasn't obvious to me because I don't work with the Properties window open)

LOL

Thanks anyway, Rob!
VBAjedi [swords]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top