Opening a user for from a Custom Toolbar

[Dave C]

I have a couple of userforms that I want to open by providing a custom
toolbar. I guess I would do this by placing macros on the toolbar but can
someone advise how I would reference the userforms within the macro?

Thanks .. Dave

 

[spunkymuffmonkey]

Hi Dave,

One way would be to created a sub within the document or a new module that
simply loads the userform, e.g.:

Public Sub ShowUserForm1

Userform1.Show

End Sub

and then link the button to this sub, capice?

 

[Dave C]

Thanks .... that was so simple it was untrue

Hi Dave,

One way would be to created a sub within the document or a new module that
simply loads the userform, e.g.:

Public Sub ShowUserForm1

Userform1.Show

End Sub

and then link the button to this sub, capice?

 

[spunkymuffmonkey]

It's only easy when you know how!!

Thanks .... that was so simple it was untrue