Converting an embedded macro to VBA code

[Lou_Reed]

I want to convert an embedded macro that is associated with a button on a form. There is a choice on the ribbon to convert the form's macro's to VBA code. I do not want that. That would convert all macro associated with this form to VBA code. I just want to convert a selected macro to VBA code; not al the macros associated with this form.



How to I do that?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Bulzie]

Why not just convert them all, VBA is easier to read and manipulate I think.

But you could copy that form, do the convert on that copy, then copy and paste the VBA code, go back to your original form and instead of macro choose to use an expression for that button and paste the code.

[Lou_Reed]

Yes, I just thought that there was a way (an easy way) to convert one control on a form and not have to do all of them. There must
be. I vaguely remember using it.

Respectfully,

Lou Reed