Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Garry
EmpList is a collection of Employees. Employees is a collection defined in my Class module as something with a few properties including badge number, first and last name, and a bunch of man hour fields. E is short lived employee that comes from a chunk of data and is added to the collection if and only if it is not already a member (badge number exists) of the collection. I use this technique a lot to simply get a unique list of something. It works great, resuming next and generating a unique collection; until I try to skip a couple other steps like putting the skipped name in a listbox. There is no code, or at least no code that I am aware of, to the EmpList.Add. It is the method for adding to a collection that exists simply by virtue of EmpList being a collection. Ken On Jul 8, 10:09*am, GS wrote: Can you show the code for EmpList.Add()? Also, why are you resetting E each time? Seems to me that this might be causing some conflict since I don't see the connection between Employee and EmpList. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding validation fails with automation error | Excel Programming | |||
Adding to A Collection | Excel Programming | |||
Automation Error(-2147467259) in Properties Collection | Excel Programming | |||
Automation Error(-2147467259) in Properties Collection | Excel Programming |