Susan Harkins
harkins at iglou.com
Mon Apr 7 14:47:21 CDT 2003
If a CommandBarControl on a menu bar contains submenus, how do I cycle
through that control's collection to list the submenus? This is driving me
nuts -- I can't figure out how to reference a control's Collection -- does a
control have a collection? I'm assuming it does if there are submenus?????
Dim cbarMenu As CommandBar
Dim cbarControl As CommandBarControl
Dim cbarSub As CommandBarControl
'Dim cbarcolControls As CommandBarControls
Set cbarMenu = CommandBars(barname)
For Each cbarControl In cbarMenu.Controls
If cbarControl.Id = controlname Then
For Each control in cbarControl's collection...
This is where I get lost -- at this point, I need to declare cbarControl's
collection, and I can't get it.
Susan H.