Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
VBComponent Types
Who has a list of all the VBComponent Types are? Thanks Todd Huttenstine |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Todd,
Set a reference to the VBA Extensibility library, and the search the Object Browser for vbext_componenttype. You'll see that there are 5 types: vbext_ct_ActiveXDesigner (=11), vbext_ct_ClassModule (=2), vbext_ct_Document (=100), vbext_ct_MSForm (=3), and vbext_ct_StdModule (=1). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... VBComponent Types Who has a list of all the VBComponent Types are? Thanks Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
VBIDE.VBComponent | Excel Discussion (Misc queries) | |||
Relating Worksheet(I).Name with VBComponent(J).Name | Excel Programming | |||
problem with wkbk.VBProject.VBComponent | Excel Programming |