Search results for query: *

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

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...

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

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...

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

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?

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

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...

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

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...