Checkbox 'ticks' after clicking 'cancel' in resulting InputBox

[Dazzur91]

Good afternoon, extreme beginner with VBA.

I debated whether or not to upload a sample workbook as per the rules as I think this is rather simple.

I have a Checklist, consisting of several check boxes, when one of these in particular is ticked, a message box pops up asking the user to confirm the information required, however if the user clicks 'Cancel' the box will still tick as if the information was inputted.

Is there a way to stop it from tickiing upon a user pressing cancel?

the basic code is as follows:

Please Login or Register  to view this content.

[6StringJazzer]

There are lots of reasons to attach an actual file, even if you think your question is simple. The code you posted is not sufficient to give you a reliable answer to your question.

Note that you are using an Input Box, not a Message Box.

There is nothing in the code you posted that would cause the checkbox to be unticked. Not sure why you expect that to happen.

Where is Line declared and what is its value when this code runs?

What kind of response is the user expect to give in the InputBox?

Based only on the one line of code you gave us I might try this.

Please Login or Register  to view this content.