what error? just looking at this, i can see how using zAs() as vbA would be a problem. because you shouldn't use the Type to define the Type. Like: you shouldn't use a word to define itself.
also, I wouldn't suggest using "vba" as a "type". the term "vba" has it's own definition. IF microsoft uses "VBA" anywhere, (which I don't know if it does or not) then you run the risk of redefining it. ... and capitalizing the "A" doesn't make a differenct. have you tried looking at the Help for the "Type" statement? the example in Help is: Type StateData CityCode (1 To 100) As Integer ' Declare a static array. County As String * 30 End Type Dim Washington(1 To 100) As StateData -------------------------------------------------------------- so, given your example, you MIGHT be able to use: Public Type vbA zAs() as string end type perhaps you need to look into the uses of Type declarations. Paul ________________________________ From: Lars Schouw <schou...@yahoo.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Fri, May 21, 2010 11:50:59 AM Subject: $$Excel-Macros$$ circular dependencies between modules I get an error when I compiled this code: Option Explicit Option Compare Text Option Base 0 Public Type vbA zAs() As vbA End Type How can I have a list of elements vbA under my type vbA? Lars -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
