[AccessD] Excel - HOW TO SEE MY MODULES COLLECTION

Hi John,

Make sure you have the properties window visible (View > Properties or
F4).  Then in the project explorer window click on the class "Class1"
under the Class Module Folder.  In the properties window under the
"Alphabetic" tab the top option will be "(Name)".  You can change the
module name here from "Class1" to "Whateveryouwant".  There are some
restrictions as in Access on what you can call a module, but that should
get you started.

Cheers
Darryl.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, 19 March 2010 1:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel - HOW TO SEE MY MODULES COLLECTION

Darryl,

Thanks for the offer.  I am trying to create a class (of course ;)

I can create the class but it automatically gives it the name Class1 and
I can't figure out how to set the name, or change the name once created.
Excel has a ways to go to match the friendliness of Access.

So how do I change the name?

John W. Colby
www.ColbyConsulting.com


Collins, Darryl wrote:
> John,
> 
> Coding in Excel in my bread and butter.  Feel free to ask on or off 
> line.
> 
> The VBE is very similar to MS Access - if you can code in VBE Access 
> you will pick up Excel very quickly.  Open Excel, and press F11 to 
> open the VBE
> 
> In the VBE goto the View option on the menu
> 
> Ensure you can view
> 1: Project Explorer (Ctrl+R)
> 2: Code Window (F7)
> 3: Properties (F4)
> 4: Locals Window (not absolutely necessary but very handy I find).
> 
> In the explorer window you will only the sheet modules.  You can code 
> directly into these, but I usually put everything in modules.  Insert 
> Module will create a standard Module just like in Access.  You can 
> also insert Class modules (I know you like to play with those
classes).
> 
> 
> "Option Private Module" up the top of the module will keep the code 
> hidden from the user. I nearly always use this along with "Option 
> Explicit" (just like Access).
> 
> 
> 
> An Excellent mailing list for Excel help are:
> http://peach.ease.lsoft.com/scripts/wa.exe?A0=EXCEL-G <for general
> stuff>
> http://peach.ease.lsoft.com/scripts/wa.exe?A0=EXCEL-L <coding and more

> advanced stuff>
> 
> X-posting is usually not necessary as most folks (including me) are 
> subbed to both lists.
> 
> I hope this helps.
> 
> Cheers
> Darryl
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."