VBA Help - Compile Error Can't find project library using Format or Left Function

[bobby_smith]

Hi Guys,

I'm trying to use some defined functions that I created back in 2014 which worked perfectly then (its been about 2 years since I used it).

Now when I use it, I get the message "Compile error: Cant find project or library.

One of the function uses format and the other use Left

In the function below, I would type =GO( ) select a cell and the result should be for example GO09.

Function GO(number) As String
GO = "GO" & Format(number, "0#")


For the one below, I would type =Fasmonths( ) select a cell and the number should be converted to months.

Function FasMonths(Estimated_Life)
If Estimated_Life < 13 Then
FasMonths = Estimated_Life
ElseIf Estimated_Life > 12 Then
FasMonths = Left(Estimated_Life, Len(Estimated_Life) - 2) * 12 + Right(Estimated_Life, 2)
End If

End Function

 

[ZVI]

Look into VBE-Tools-References and unselect references started with "MISSING:...".
Usually it's invalid reference to Ref Edit Control.

 

[bobby_smith]

Thanks a MILLION ZVI. It worked... I've been searching for solution for so long and you came to my rescue.
Thank you very much.

 

[ZVI]

... It worked...

Happy to know it has helped!

 

[greatglern]

I solved a problem with the “mid” function causing a compiler error using your, “Look into VBE-Tools- References and unselect references started with "MISSING:...".” However, I wasn’t given any, “Cant find project or library.” Information.

I burn a lot of time with VBA issues generated by Windows updates (or Office update with a Windows update). This “MISSING…” issue was new; usually the VBA modules are deleted from the Excel file. Can you tell me a little about what “MISSING….” is, how it gets in and if there is anything I should do?