Command bar diclaration

[areddy]

Hi All,

How to declare commandbar in visual basic6.0

in excel visual basic editor iam declaring as

Dim oCB As Commandbar

i declare same as above but it is saying

Compile error:
User-Defined type not defined error is coming.

How we have to declare in visual basic.

Thanks&Regards,
Amar...

 

[Guest]

assuming that you have a reference set to th eexcel objects library

Dim xl As Excel.Application
Dim wb As Excel.Workbook
Dim oCB As Object

Set xl = New Excel.Application
xl.Visible = True
Set oCB = xl.CommandBars.Add("test")
oCB.Visible = True

 

[Tushar Mehta]

In XL VBE check the established references (Tools | References...)
That should tell you which library your VB code should reference to use
early binding with commandbars.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions