ActiveX Buttons in Ribbon

Hi All, I'm creating a custom tab in the ribbon where I have assigned the applicable buttons that I currently have assigned to the workbook.

The buttons are ActiveX and have been coded that way, How do I assign the correct code to the buttons in the ribbon?

I managed to get half of them to work (mainly the ones that just call 'UserForm.show' for example), but with others that have various references to tables and scripts and the code for some is fairly complicated, it just does not work.

How do I go about this? not sure what info you will need so please ask and will provide you with such.

Originally Posted by rorya

You can't put activex buttons in the ribbon, if that's what you are saying.

Ribbon buttons use callbacks, but for existing macros you can just add them to the ribbon and everything is done for you, so I'm not really sure where you are stuck?

Okay, well I’m not sure why there’s a ribbon button for activex? That’s very confusing… however what I did do that made some work was literally copy paste the code from the sheet into a module. I do know that this is the wrong way of doing it.

But now if what you say is true, how do I turn my activex buttons to normal command buttons?

Just to clarify, as per the attached pictures, the ActiveX command button is not an ActiveX button? That's very confusing!

What I was saying is copy pasting the full code applied to the buttons into a module.

What are my other options here since i cannot assign my current ActiveX controls into the ribbon?

There is another bit of code which updates by CLS_Record which i am not allowed to post here.

Errors such as "Private WithEvents FormRecEntry As UserForm1" not allowed.

Using "with me." says its invalid.

and how do I do that?
so for eg. I would replace all "Me." with "Sheet1."?
Then place all the variables listed at the top into a new module?

Then after ActiveX buttons will work in the ribbon?

I'm getting an "error424Object"

If I didn't know that already I would have told you it doesn't work instead of listing the actual error.

Many thanks man, I got it done.. All that I did was change private to public and kept the code where it was. works perfectly.