Userform loop thru checkboxes and if true......

[rpinxt]

Kind of strugling with a userform in which I have made 3 checkboxes.

The idea is that the user get the userform and can select 1 to 3 of the options.
Then a button 'Go' will need to set of some vba code which loops thru the 3 checkboxes to see what was chosen.

When true its needs to do something and when false just go on to the next box.

[rpinxt]

I did find this code :

Please Login or Register  to view this content.

But that is not doing more then giving the names of the checkboxes I made.

Obviously like this it is no use to me.

[rpinxt]

Another code i tried:

Please Login or Register  to view this content.

But this gives me "object variable or with block variable not set" error

This code however describes best what i want I guess.

[mikerickson]

In post #2, replace the message box with the code to do what you want.

[rpinxt]

yeah but there are 3 checkboxes, so it should look 3 times and depending on the true or false of the checkbox do "something"

[Kenneth Hobson]

Please Login or Register  to view this content.

[rpinxt]

Superb Kenneth!

Thanks a lot, works like a charm.