Libraries In Excel VB Editor

C

ccdubs

Hi,

I have a VB function that uses the Left and Right functions. I.e., returns
specified charecters in a string.

The problem is that since reformatting my hard drive, I can't use these
functions. They work on a normal spreadsheet but not in VB.

The error is "can't find project or library".

I have looked at the references menu and the only outstanding thing is that
it says that Microsoft Windows Common Controls is missing.

Can anyone help?

Cheers
 
C

ccdubs

No need to answer.

I solved the problem by unchecking the Microsoft Windows Common Controls
reference.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Editor References 1
VB macros in new Excel 24
missing library makes Format() disappear 2
Excel 2003 with VBA - "Can't find project or library" 6
Missing MS Windows Common Controls (SP4) VB 6 2
Calling VB functions that are stored in an addin 3
Array() function whacks out Excel 2007 3
Set an object variable to the vb editor itself 1

Top