Data-Definition Problem

Howdy:

I have two spreadsheets, one has a routine that works and the other fails with "User-Defined type not defined". Here's the code that is identical in both spreadsheets:

Please Login or Register  to view this content.

On the spreadsheet that this statement fails, when I'm typing in the dim statement, I get a listing of appropriate selections for the "As" part of that statement. In the spreadsheet that works, "DataObject" is a selection (and, hence, why it works) but the other doesn't (hence, why it does not). How can it be different.

Right now, just color me confused.

Bob

You need to add a reference:

VBEditor (Alt-F11)/menubar/Extra/references/Microsoft Forms 2.0 Object Library : check.