Date formatting in VBA WinXP / Win 7 errors

[danmarson]

Hi all,
i build a tracker using userforms in Windows 7 and it works fine but for some reason on windows XP machines its throwing up a compile error for this piece of code in the Userform_initilize

Please Login or Register  to view this content.

it specifically doesnt like the word "Date"

and in another piece of similar code it doesnt like the word "format"

Please Login or Register  to view this content.

The specific error is "cant find project of library and it highlights the

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

I dont understand why its fine on Win 7 but not on XP,
any suggestions?

both are using Excel 2007

taking out the format string and just using it as a value and it works fine on XP and win 7

many thanks

[JosephP]

you have a missing reference. on the xp machine in the vbe click tools-references and look for a selected item marked 'MISSING:'

you can resolve the problem by fixing the reference issue or bandaid it using VBA.Date and VBA.Format rather than just Date and Format

[danmarson]

perfect thank u that fixed it!