ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format error (https://www.excelbanter.com/excel-programming/360035-re-format-error.html)

Tom Ogilvy

Format error
 
when you get the message, go into the vbe and go to tools=references (you
may have to hit reset button). In the references you should see one or more
marked as MISSING. that is the source of your problem. Get your references
straightened out and you shouldn't get the message.

--
Regards,
Tom Ogilvy


"Patrick Simonds" wrote:

I crashed my computer and had to reinstall Windows XP pro and my Office
2002. Now when I open my spreadsheet I get the following error:

Can't find project of libary and it is choking on Format in the following
line:

TextBox15.Text = Format(TextBox15.Text, "dddd dd mmmm yyyy")

I have downloaded all updates to Office 2002 and I also tried installing it
on my kids computer. On their computer I get no errors and everything works
fine.

Sorry about the repost but my system came back with a message deleted from
server.





All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com