Code in a form and have it as a button or button in ribbon

[drop05]

Hello, i created a Form in the VBA editor and have code inside it. I am trying to find a way to have a button on a page or in the ribbon so it can be clicked and pop up the form (GUI) so it can run the code inside it, but not sure how to do so, when creating a button it is only letting me assign subs that are in my moduels

 

[288enzo]

Hello, i created a Form in the VBA editor and have code inside it. I am trying to find a way to have a button on a page or in the ribbon so it can be clicked and pop up the form (GUI) so it can run the code inside it, but not sure how to do so, when creating a button it is only letting me assign subs that are in my moduels

You could create a sub that references the form?

 

[drop05]

You could create a sub that references the form?

I suppose so, but how could i do that? The same as calling a sub? If i have the form called "frmImport"

 

[288enzo]

I suppose so, but how could i do that? The same as calling a sub? If i have the form called "frmImport"

If your form name was UserForm1, then your sub would be something like:

    With UserForm1
        .Show
    End With