Userform detail

[mackinlay]

Hi guys,

I am looking to put a bit of code into my userform so that if I tick a checkbox and go to the next form, but then hit cancel on the next form and return to the first form, the checkbox can then be un-ticked.

The code I am using so far for the first form checkbox is simply:

Please Login or Register  to view this content.

and for the second form cancel button:

Please Login or Register  to view this content.

So, in other words, I am looking for the code to go into the second form cancel box to uncheck the checkbox in the first form.

Any takers would be much appreciated!!

Cheers,

Alex

[Leith Ross]

Hello Alex,

To reference another control on another UserForm, You need to qualify it with the name of the other UserForm and that UserForm must be loaded. Change the names of UserForm and CheckBox to match yours.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[royUK]

Why not use a multipage control on the userform 7 then you wouldn't need multiple forms.

[mackinlay]

Hi leigh,

When I use the code:

Please Login or Register  to view this content.

I'm getting the error message:

"Run Time Error 400. Form already displayed; Can't show modally"

I was wondering if you know how I can fix this?!

Further to this, if I re-write the code as:

Please Login or Register  to view this content.

then I dont get an error message and the box dose un-check, but it takes 2 clicks to complete the actions, rather than one...

Cheers,

Alex