Learning VBA-don't understand error message
 

Im starting to studying a new macro book that I just got, and in the current
section that Im in, there is section that is called €œUsing user types with
arrays€�. They have a sample code that I typed in a new spreadsheet, but when
I run the macro, I get this error

€œcannot define a Public user-defined type within an object module€�

My code that is causing the error is this, and I have checked several times
that I have typed the code in correctly.

€œType salesResults
spring As Single
summer AS Single
fall As Single
winter As Single
End Type€�

I have search the VBA help, to find out to try and correct this error, but
havent found anything that is close to answering it for me.

Can explain to me what I have done wrong.

Cal

Learning VBA-don't understand error message
 

Forgot to mention that this is being done in VBA version 6.5, and Excel
verison 2002.

Cal

Learning VBA-don't understand error message
 

You could have put the code under the ThisWorkbook module or under a
worksheet--or even in a class module.

You want to put that code in a General module:
With your workbook's project active:
Insert|Module
Is one way of getting there.

beginner here wrote:

Im starting to studying a new macro book that I just got, and in the current
section that Im in, there is section that is called €œUsing user types with
arrays€�. They have a sample code that I typed in a new spreadsheet, but when
I run the macro, I get this error

€œcannot define a Public user-defined type within an object module€�

My code that is causing the error is this, and I have checked several times
that I have typed the code in correctly.

€œType salesResults
spring As Single
summer AS Single
fall As Single
winter As Single
End Type€�

I have search the VBA help, to find out to try and correct this error, but
havent found anything that is close to answering it for me.

Can explain to me what I have done wrong.

Cal

--

Dave Peterson

Learning VBA-don't understand error message
 

There is noting fundamentally wrong with that code.

It does need to be at the head of a module, before ant macros, and after
Option statements. Is that where you put it?

--
__________________________________
HTH

Bob

"beginner here" wrote in message
...
I'm starting to studying a new macro book that I just got, and in the
current
section that I'm in, there is section that is called "Using user types
with
arrays". They have a sample code that I typed in a new spreadsheet, but
when
I run the macro, I get this error

"cannot define a Public user-defined type within an object module"

My code that is causing the error is this, and I have checked several
times
that I have typed the code in correctly.

"Type salesResults
spring As Single
summer AS Single
fall As Single
winter As Single
End Type"

I have search the VBA help, to find out to try and correct this error, but
haven't found anything that is close to answering it for me.

Can explain to me what I have done wrong.

Cal

Learning VBA-don't understand error message
 

User defined tupes can only be placed in standard code modules. You can not
put them in worksheet modules, thisworkbook or in forms. That would be my
best guess as to what is happening...
--
HTH...

Jim Thomlinson


"Cal" wrote:

Forgot to mention that this is being done in VBA version 6.5, and Excel
verison 2002.

Cal

Learning VBA-don't understand error message
 

To add:

If this is in an object (class) module you could get it to work by making it
Private (Private Type salesResults), but then it's not directly accessible
outside that object. If you want to make the Type publicly available by any
code in the VBA project (Type salesResults or Public Type salesResults, same
thing), move it to a standard module, not a class module. Everything is a
class module in Excel except the one from Insert - Module.

To read more in the help file, search for "Type Statement". However, I
believe the help file misstates the functionality a bit:

"In standard modules and class modules, user-defined types are public by
default. This visibility can be changed using the Private keyword."

Perhaps it would be helpful if it also noted, "Note that in Excel, a public
Type is allowable only in a standard module."


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"beginner here" wrote in message
...
I'm starting to studying a new macro book that I just got, and in the
current
section that I'm in, there is section that is called "Using user types
with
arrays". They have a sample code that I typed in a new spreadsheet, but
when
I run the macro, I get this error

"cannot define a Public user-defined type within an object module"

My code that is causing the error is this, and I have checked several
times
that I have typed the code in correctly.

"Type salesResults
spring As Single
summer AS Single
fall As Single
winter As Single
End Type"

I have search the VBA help, to find out to try and correct this error, but
haven't found anything that is close to answering it for me.

Can explain to me what I have done wrong.

Cal