Recent content by MrMeReturns

Does anyone know how to go about saving the data you have associated with one tab on a tab strip before switching to a new tab? All of the events that I have looked at make the switch to the new tab before executing any code so you can't run a function to save the data that is associated with...

I have been trying to get the Solver to run in Excel XP VBA but I keep getting an error saying an unexpected error has occured or the machine has run out of resources. Also the function text itself is acting a bit wierd. Instead of turning blue and capitalizing the appropriate letters like...

I have been trying your idea of using the 'Dictionary Object', it works pretty slick :-) Thanks for your help, MrMeReturns

I want a string value to be interpreted as a variable name. For example sTest = "i" & objControl.Name dTest2 = CDbl(objControl.Value) adImpericalData(sTest) = dTest2 'This is an array ""i" & objControl.Name" form the name of a constant...

That works well. Thanks Rob MrMeReturns

I have a For Each loop loopping through all of the controls on a form. I would like to identify when the current control selected by the loop is a textbox. In VB6 there is the TypeOf statement. Is there a similar statement in VBA?