View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default CommandBarControl class

John,

No, that's not possible. You need to use the Add method of the
Controls collection to create the new object. Among other things,
the CommandBarControl object needs to have a Parent object, its
container, so you can't create a new CommandBarControl directly.
Use .Add.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John A Grandy" wrote in message
...
apparently, this is not possible ...

Dim cbc As CommandBarControl
Set cbc = New CommandBarControl

??