Command bar diclaration

[areddy]

Hi All,

somebody has sent the answers thanks for them but that is not working.

pleas help me on this.
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...

 

[Tushar Mehta]

See the response(s) to the same question you asked earlier maybe in a
different newsgroup.

--
Regards,

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

 

[Patrick Molloy]

my answer was copied from my VB6 test. You need to set a reference to the
Microsoft Excel Library