Using a worksheet command button to start userform initialize procedures

Hello,

I previously created a worksheet with a command button which had the code

Please Login or Register  to view this content.

. The userform had a procedure under

Please Login or Register  to view this content.

. When I clicked the command button on the worksheet it opened the form in the way instructed under the initialize procedures.

I am creating almost the same thing but the code no longer works. When I use the

Please Login or Register  to view this content.

, it shows the form but does not open it as per the initialize procedures.

How can I get a command button that is on a worksheet to start the initialize procedures of a userform? And why did it work the first time but not again?

stuck???

Help appreciated

Originally Posted by Norie

Have you changed anything?

Perhaps the name of the Initialize event.

I have changed everything as i am working on a completely new project, however I have used the same method i.e placing a command button on the worksheet and then using the code as stated above.

I know that the initialize event works as when I place a command button on the userform to trigger the initialize event it works fine.

The problem seems that the command button on the spreadsheet cannot "read" the initialize event on the userform.

Do I need to put something on a module?

Originally Posted by Winon

Hello paulary30,

Did you perhaps added another UserForm? If so, refer to the actual UserForm you want to open or show via the Command Button.

Alternatively, upload a sample WorkBook of your problem, complete with your code and UserForm/s, for us to have a look at.

I am unable to send my example as it is a huge spreadsheet and has sensitive information re my work on it.

I created a dummy spreadsheet with a command button and a userform and that seemed to work. I am stumped!

Do procedures have to be in certain orders?

Tried that and it still would not work. It shows the form but I have to press another button (which is on the form) to get the initialize events to start.

I am v frustrated

For some strange reason it is now working on one of my forms and not the other. I have just moved the order about. I will try to do the same with the other.