Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code won't run
I wrote some code in Excel 2003 but I can't get it to run in Excel 2000. The
real problem is that I don't know why. The current line of code is: MsgBox "Some required information is missing." & Chr$(10) & "Please ensure all entries are complete." & Chr$(10) & "This file has not been saved.", vbCritical, "Missing Information" It gives me an error at the Chr$ part. The error is Compile Error: Can't find project or library What is wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code won't run
In the VBIDE, go into ToolsReferences, and if there re any items marked as
MISSING, uncheck them. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keith" wrote in message ... I wrote some code in Excel 2003 but I can't get it to run in Excel 2000. The real problem is that I don't know why. The current line of code is: MsgBox "Some required information is missing." & Chr$(10) & "Please ensure all entries are complete." & Chr$(10) & "This file has not been saved.", vbCritical, "Missing Information" It gives me an error at the Chr$ part. The error is Compile Error: Can't find project or library What is wrong? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
code won't run
Hi Bob,
That worked a treat. Thanks. Regards Keith "Bob Phillips" wrote: In the VBIDE, go into ToolsReferences, and if there re any items marked as MISSING, uncheck them. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keith" wrote in message ... I wrote some code in Excel 2003 but I can't get it to run in Excel 2000. The real problem is that I don't know why. The current line of code is: MsgBox "Some required information is missing." & Chr$(10) & "Please ensure all entries are complete." & Chr$(10) & "This file has not been saved.", vbCritical, "Missing Information" It gives me an error at the Chr$ part. The error is Compile Error: Can't find project or library What is wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |