akohan
asked on
Question on Excel 2003 and VBA coding
Hello group,
I just used my application on a machine with the same Windows (XP) and same office version (2003) but the following code causes an error:
With userFormDesktop.cbxYear
.Font.Bold = True
For nYear = (Year(Date)) To 1996 Step -1 <<<<<< can't find object or library
.AddItem Trim(CStr(nYear))
Next
Your help will be appreciated.
regards,
ak
End With
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much.
ASKER
Right. It was
MISSING: fpdtc 1.0 Type Library.”
It unchecked the reference option and it is running well.
Thanks,
ak