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



"areddy" wrote:


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


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