It appears though that programming with (vba) for excel 2000
and vb.net are
two completely different worlds.

Yes, they are quite different. In VBA, a class module contains
one and only one class, whose name is the name of the module. For
your code, first create a new class module, F4 to bring up the
Properties window, and give it a name of LedgerTransaction. In
that module, put the following code:

Public Items As Collection
Public Index As Long

Private Sub Class_Initialize()
Set Items = New Collection
End Sub




Next, create a second class module, name it BankAccountLedger,
and place the following code in that module:

Public Name As String
Public Transactions As Collection
Public LedgerRange As Range

Private Sub Class_Initialize()
Set Transactions = New Collection
End Sub

Then, in your initialization code in a regular code module,
instantiate the classes with code like

Dim LT As LedgerTransaction
Dim BAL As BankAccountLedger
' other code
Set LT = New LedgerTransaction
Set BAL = New BankAccountLedger


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





"WStoreyII" wrote in
message
...
I dont have much programming experience, but the little that i
do know is from visual basic.net. It appears though that
programming with (vba) for excel 2000 and vb.net are two
completely different worlds.

So what i need to know is how to make a class or an object that
i can manipulate in my code

I wish to make a Class that Will Be Called LedgerTransaction
this class will have two member variables
1) Items - which will have a collection of range objects that
contain the range of the particular transaction item
2) Index - which will be the index of the transaction

I will also need a class called BankAccountLedger
Wich will have three Member Variables
1) Name
2) Transactions - Collection of Transactions
3) Range the range of the ledger

now this is a very elementry process in vb.net
and i am sure that it is in vba to.
however i am missing something
i tried a classs module
and a user defined types
and received several different error messages.

If anyone could please help me understand this or send me to a
good tutorial i would be very grateful

WStoreyII