| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace VBA run-time error message with custom message | Excel Programming | |||
| Formula error, don't understand why... | Excel Discussion (Misc queries) | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| dont understand compile error | Excel Programming | |||
| Don't understand External Data message | Excel Programming | |||
Threaded Mode
