Creating a worksheet ActiveX button via code seems different than one from Control Toolbox

[Oppressed1]

Note this may be version specific; I'm on 2003. In 2003 View/Toolbar/Control Toolbox and drag command button to sheet to create a command button. Then in design mode, right click, and you see "properties" where you can, e.g. set an accelerator.

But if you use the code below (which is what macro recorder shows for what I just described, by the way) (and matchs Help example for Add method for OLEObjects), right clicking has no "properties", and the button is not as versatile - for example, I have been unable to set an accelerator. Can someone explain the difference? (BTW, browsing the watch window shows both are OLE type 2, but there are other property differences apparent from comparing in the watch window).

Please Login or Register  to view this content.

[mjr veverka]

There is a little reading to read about it, e.g. Ms context help in vba.
'Using ActiveX Controls on a Document' / 'Using ActiveX Controls on Sheets'.

[Oppressed1]

This was responded to in another thread, reproduced here.

Thank you for the useful and on point response.

No, they aren't. It's the same control

Okay, you're right. I'd still like to know if anyone knows how to add "Properties" to right click since it does not appear on the generated button (the only meaningful difference I now see).

If you wanted to add an accelerator using the code in your other thread you should only need to add

Please Login or Register  to view this content.

Sorry, you're right, my mistake - setting the accelerator for either of those that way is no problem.