clearing a variable defined by Type statement

[diddi]

hi and easter greets to all. i have set up a number of variables using the Type structure which i use for getting and putting data to Random files. eg a variable called Payment to record customer payment info such as date and payment method etc.

Type Payment
    D As Date
    cn As Integer
    Pay As Single
    Meth As Integer
    Chq As Long
    ReMare As Integer
End Type

is there a simple way to clear all values in the variable or do i have to do this?

Payment.Date=0
Payment.cn =0
Payment.Pay =0
Payment.Meth =0
Payment.Chq =0
Payment.ReMare =0

thx

 

[Zack Barresse]

Nope, you've got to set them all manually. Not sure why you'd go with a Type declaration though. They're not very user friendly IMHO. Plus they're static and only called at run time. It would seem that a class would be better. Why don't you take a read here for some good information....

http://www.cpearson.com/excel/Classes.aspx

HTH

 

[diddi]

that link looks like the perfect solution. thx Zack
i'll do some homework!