Unknown class or object name

[Aydan]

I copy/pasted code to try out something, but when trying to compile I get the message "user defined type not defined" an stops on a line with the following declaration "Dim DLG As DialogSheet".
I know that this is caused because I'm referencing a class/type which is not in my project references.

Is there a way to find out the object library in which this class is defined? In the object brouwser I could not find it becaus it searches only the referenced libraries.
Or did I mis something..

 

[VBslammer]

A DialogSheet is an outdated Excel 5.0 reference. The newer versions use a 'UserForm' instead.

If you can reference the 'Microsoft Excel 5.0 Object Library' the DialogSheet will appear in the object browser. VBSlammer

Unemployed in Houston, Texas