Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ChrisParks

    objects not behaving as distinct

    how can i set one objects values equal to another without destroying the original?
  2. ChrisParks

    objects not behaving as distinct

    nothig much to it.... a class exists, Sec_MBS with a property, SecCounter Public ThisMBS As new Sec_MBS Public TempMBS As New Sec_MBS ThisMBS.SecCounter = 20 Set TempMBS = ThisMBS at this point tempmbs properties take on all the values of thismbs properties tempmbs.seccounter is currently...
  3. ChrisParks

    objects not behaving as distinct

    i have set obj1 and obj2 both equal to objecttest which is a class so obj1 and ob2 should represent objects of class objecttest so i do not think this solution applies? maybe i am missing somethin here
  4. ChrisParks

    objects not behaving as distinct

    all i am declaring two objects with diff names, lets say obj1 and obj2 equal to new ObjectTest objects i first define all the characteristics of obj1 based on objecttest class characteristics then i want to set obj2 = obj1 but subsequently manipulate the characteristics of obj2 when i do...
  5. ChrisParks

    edate & eomonth

    edate allows you to increment a date by months ie... edate(2/15/2006,1) returns 3/15/2006 eomonth returns the last day of the month of a given date oh well, guess not thanks
  6. ChrisParks

    edate & eomonth

    these are excel functions that i use a lot im wondering if vba holds them a spot id like to use them, but not sure if i may does excel vba have an alternative way?
  7. ChrisParks

    resetting all variables

    is there a single statement that resets all of the values of variables to null? i believe there is but i cannot remember it thanks
  8. ChrisParks

    EXCEL SHEET REFERENCE

    Hey all, wondering whether any of you know if it is possible to do the following have a drop down that has say 2 options each option represents the name of a sheet on the current workbook the contents of each sheet are identical, but depending on the situation, you may want to retrieve data...
  9. ChrisParks

    collection

    Hey mstrmage1768, I think that was the solution. I'll be back asking again if it isn't, but it seems to work. Thanks
  10. ChrisParks

    collection

    hey, i am adding objecs to a collection object is called securities. collection is called securitycollection im setting variables to the properties of each "securities" object, then adding the object into the collection i am looping thru several securities that have different properties and...

Part and Inventory Search

Back
Top