Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fancy Object Declaration
Hi all... I cut my teeth on code with line numbers and goto statements... so all this newfangled object stuff is mind bending. Current issue: Trying to be good be explicit object declaration. My reward for trying to be good by declaring objects explicitly is that in some cases, where code USED to work (because VBA was smart enough to handle things without declaration) I now don't, in all cases, know what the heck object was created... Example: MyFunction() Dim oChart Set oChart = ChartSpace1.Charts(0) End Function ....used to be just dandy ....now: Substitute "Best Guess" with many different object types Public oChart as "Best Guess" ----------------------------------------------------- MyFunction() Set oChart = ChartSpace1.Charts(0) End Function chokes because my "best guess" as to what the object is suppossed to be is always wrong. Type mispatch error. How do I discover what ChartSpace1.Charts(0) is trying to create? Since VBA apparently knows what this is... (because it is aware of the mismatch) I wonder why the Error message fails to say? Anyway, advice on declaring this properly is very much appreciated. Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fancy Object Declaration
rci wrote:
Belay that... I discovered the TypeName() method of determining the exact object. Best regards, Mike : Hi all... : I cut my teeth on code with line numbers and goto statements... so all : this newfangled object stuff is mind bending. : Current issue: Trying to be good be explicit object declaration. : My reward for trying to be good by declaring objects explicitly is that in : some cases, where code USED to work (because VBA was smart enough to handle : things without declaration) I now don't, in all cases, know what the heck : object was created... : Example: : MyFunction() : Dim oChart : Set oChart = ChartSpace1.Charts(0) : End Function : ...used to be just dandy : ...now: Substitute "Best Guess" with many different object types : Public oChart as "Best Guess" : ----------------------------------------------------- : MyFunction() : Set oChart = ChartSpace1.Charts(0) : End Function : chokes because my "best guess" as to what the object is suppossed to be is : always wrong. : Type mispatch error. : How do I discover what ChartSpace1.Charts(0) is trying to create? Since VBA : apparently knows what this is... (because it is aware of the mismatch) I : wonder why the Error message fails to say? : Anyway, advice on declaring this properly is very much appreciated. : Thanks, : Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Workbook Declaration | Excel Discussion (Misc queries) | |||
fancy lookup | Excel Worksheet Functions | |||
Need to do a fancy string copy plus | Excel Discussion (Misc queries) | |||
Declaration? | Excel Programming |