Command bar diclaration
 

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

Command bar diclaration
 

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

Command bar diclaration
 

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

In article ,
says...

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