ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ?thisworkbook.VBComponents(5).Type returns 2 (https://www.excelbanter.com/excel-programming/318864-thisworkbook-vbcomponents-5-type-returns-2-a.html)

[email protected][_2_]

?thisworkbook.VBComponents(5).Type returns 2
 
Following an upgrade to XPpro, my immediate window more often than not
returns integer codes such as the above, rather than the corresponding
type constant (vbext_ct_ClassModule in this case)
What have I forgotten to set?

Matthew


Tom Ogilvy

?thisworkbook.VBComponents(5).Type returns 2
 
I've never seen it return anything but the number.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Following an upgrade to XPpro, my immediate window more often than not
returns integer codes such as the above, rather than the corresponding
type constant (vbext_ct_ClassModule in this case)
What have I forgotten to set?

Matthew





All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com