Hi Jennifer

I have a feeling (may be wrong here, so apologies if I'm leading you up
the garden path so-to-speak) that Excel may be getting confused with
the Format command. Try preceding it with VBA ie:

txtDate3.Value = VBA.Format(Me.txtDate3, "")

txtPriceLB.Value = VBA.Format(Me.txtPriceLB.Value, "$#,###,###.00")

Give it a try and see if it changes anything.

Richard


Jennifer wrote:

I have looked at previous answers to this question but i need it explained a
little further please.
I created a workbook in Excel '03 and sent it to my Dad. He also has Office
2003, so why does he get the error: Can't find project or library when trying
to run the the workbook. I have gotten on his computer and in VBA gone to
TOOLS References but i don't seeing anywere that has "Missing" attached to
it. And i don't know where else to look. The following are lines i am having
trouble with

<<< txtDate3.Value = Format(Me.txtDate3, "")

<<< txtPriceLB.Value = Format(Me.txtPriceLB.Value, "$#,###,###.00")

Since this works with no problems on my computer; how do you suggest i know
in advance what will work on my dads computer. He is getting frustrated with
me when we run into these little glitches. Thank you in advance.
--
Thank you,

Jennifer