Solved

default values for properties.

Posted on 2002-03-06
2
216 Views
Last Modified: 2013-11-23
I'm sure this is really easy, but I'm not totally up on my VB knowledge, so would liek to know how I can declare lots of global variables, give them aa default values, and then have LET/ GET property declarations to override the defaults?

This is what I have so far:

Dim mProdCode As String
Dim mItemName As String
Dim mManufacturer As Integer
Dim mCollection As Integer
Dim mCategory As Integer
Dim mMaterial As Integer
Dim mCurrPage As Integer

Public Property Get ProdCode() As String
    ProdCode = mProdCode
End Property

Public Property Let ProdCode(ByVal vNewValue As String)
    mProdCode = vNewValue
End Property

Public Property Get ItemName() As String
    ItemName = mItemName
End Property

Public Property Let ItemName(ByVal vNewValue As String)
    mItemName = vNewValue
End Property

Public Property Get Manufacturer() As Integer
    Manufacturer = mManufacturer
End Property

Public Property Let Manufacturer(ByVal vNewValue As Integer)
    mManufacturer = vNewValue
End Property

Public Property Get Collection() As Integer
    Collection = mCollection
End Property

Public Property Let Collection(ByVal vNewValue As Integer)
    mCollection = vNewValue
End Property

Public Property Get Category() As Integer
    Category = mCategory
End Property

Public Property Let Category(ByVal vNewValue As Integer)
    mCategory = vNewValue
End Property

Public Property Get Material() As Integer
    Material = mMaterial
End Property

Public Property Let Material(ByVal vNewValue As Integer)
    mMaterial = vNewValue
End Property

Public Property Get CurrPage() As Integer
    CurrPage = mCurrPage
End Property

Public Property Let CurrPage(ByVal vNewValue As Integer)
    mCurrPage = vNewValue
End Property

I've had a look at stuff on Constructors, but can't see this applying to this, as ultimately this will be a COM object.
0
Comment
Question by:AlfaNoMore
2 Comments
 
LVL 9

Author Comment

by:AlfaNoMore
ID: 6844466
I HATE THAT!!!!

Just posted this question, and IMMEDIATELY found the solution!!!

Private Sub Class_Initialize()
   mvarValue = 0
End Sub

I'll get this deleted then...
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6844509
Don't hate it, it's great.  You posted a question and added the solution, this could help others.  I refunded the 50 points to you and will move to the PAQ at zero points to close it.

Thanks,

Moondancer
EE Moderator
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now