Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Process control chart for quality control in exel? | Charts and Charting in Excel | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Shift-Control Arrow and RefEdit Control? | Excel Programming |