Results 1 to 2 of 2
Thread: some basic questions (excel2000)
2004-07-03, 15:07 #1
- Join Date
- Jul 2004
- Hamburg, Germany
- Thanked 0 Times in 0 Posts
some basic questions (excel2000)
My apology for these basic questions :
1. How can I rename a module, So far I always get only the default one like Module1, Module2 etc.
2. What is the difference between module and class module?
3. Is that possible to have more than 3 conditions in conditional formatting?
Can anybody so kind to answer my questions ( I am optimistic as I learn only nice people stays in this lounge)
PS. Tony, so far one link has solved my problems. Waiting your next suggestions the have another link. <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>
2004-07-03, 15:25 #2
- Join Date
- Jan 2001
- Thanked 1 Time in 1 Post
Re: some basic questions (excel2000)
1/ To rename a module first make sure the properties window is displayed (press F4). In the Project Explorer click on the Module you want to rename, you can then change its name within the properties window.
2/ A Class Module is a special type of module that enables the programmer to create a new object class. You can create new objects along with corresponding properties, methods and events. This link gives an overview of class modules.
3/ You can only have up to 3 conditions using the built in conditional formatting within Excel, but you could use VBA if you want more than 3 conditions.