Creating Menu Items In The VBA Editor -Code from chip pearson (excel 64 bit issue)

[Jaafar Tribak]

I downloaded the workbook from Chip's site but I keep getting error 438 at the following line :

[COLOR=#000080][FONT=&quot]Set MenuEvent.EvtHandler = Application.VBE.Events.CommandBarEvents(CmdBarItem)[/FONT][/COLOR]

Has anybody experienced the same problem ? Is this a bug ? The code works on excel 32bit but errors out on excel 64bit 2010.

Regards.

 

[rlv01]

Seems to be a known bug. This link suggests it might have been fixed in later versions of 64 bit Excel.

https://www.spreadsheet1.com/excel-vba-bugs.html

 

[Jaafar Tribak]

Seems to be a known bug. This link suggests it might have been fixed in later versions of 64 bit Excel.

https://www.spreadsheet1.com/excel-vba-bugs.html

Good find ! At least I now know I wasn't doing something wrong .

The article reads :

There are no alternative means to achieve the same effect, so it is not currently possible to create useable menus for the VBA Editor in Office 2010 x64

Thank you.

 

[Jaafar Tribak]

Hi all,

Could somebody who has excel 2013 x64bit please test Chip's code and confirm if it sucessfully sinks the VBE CommandBarControl Click event ?

Regards.