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

"areddy" wrote in
message ...

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...


--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=483061