Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Error Seeker Excel Discussion (Misc queries) 1 March 29th 09 10:13 AM
format error tillys88falcon New Users to Excel 1 August 19th 07 10:02 PM
format error Smooney New Users to Excel 1 August 17th 07 01:54 AM
Formula or Format Error?? DavidB New Users to Excel 3 October 17th 06 08:10 AM
Concatenate error and Date Format Error Coal Miner Excel Programming 3 April 26th 06 10:30 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"