Toggle button works on sheet but not when moved to module.

[mandora]

I placed a toggle button on a userform that toggles between two sheets. Originally, I placed the code with the button as a click event and its worked fine.

Subequently, I moved the toggle code to a standard module and called it from the forms object. The call works but the toggle code itself produces "Object variable or With block variable not set". Code follows:

Code In forms object:

Please Login or Register  to view this content.

Code in standard module with Option Explicit set:

Please Login or Register  to view this content.

I am self-taught and obviously have a lot to learn. Your help will be appreciated.

[OllieB]

The reason for the message "Object variable or With block variable not set" is probably because the form reference is missing in statements like:

Please Login or Register  to view this content.

You should change those statements to

Please Login or Register  to view this content.

where name_of_form needs to be replaced with the actual form name

Hope this helps.

[Kyle123]

You'd be better off keeping the code where it was. It's generally a bad idea to spread code around your project, it makes it painful when you need to change something in 6 months time when you've forgotten how everything works. It's easy to follow the code if it's logically grouped in the right place - i.e userform code in the userform it relates to

[mandora]

Thanks for suggestion.