coolbar control in VBA
 

hi all,

I'm trying to add a button to a coolbar control in VBA and getting nowhere. the crux of my problem is adding the control (to start with a command button) to the band container on the coolbar

when i search msdn i get code that says specify that you want to add the control to the container but it all looks good for VB rather than VBA and i can't figure out how to do it in VBA

any help much appreciated

snaps.

coolbar control in VBA
 

the menu objects in VBA are commandbars. I am not aware of a coolbar object
in VBA. As you say, coolbars are in VB.

--
Regards,
Tom Ogilvy

snapper wrote in message
...
hi all,

I'm trying to add a button to a coolbar control in VBA and getting
nowhere. the crux of my problem is adding the control (to start with a
command button) to the band container on the coolbar.

when i search msdn i get code that says specify that you want to add the
control to the container but it all looks good for VB rather than VBA and i
can't figure out how to do it in VBA.

any help much appreciated.

snaps.

coolbar control in VBA
 

tom you are correct.

what i should have said is that i am trying to use an activeXcollbar control in VBA and having the problems i described earlier

snaps