ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Libraries In Excel VB Editor (https://www.excelbanter.com/excel-programming/272781-libraries-excel-vbulletin-editor.html)

ccdubs

Libraries In Excel VB Editor
 
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



ccdubs

Libraries In Excel VB Editor
 
No need to answer.

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

Thanks


"ccdubs" wrote in message
...
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






All times are GMT +1. The time now is 09:25 AM.

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