Auto tick

[kamikizzy]

I am not sure this is possible but here goes my question.
I have 3 columns column 1 is text, column 2 is a number or text value and column 3 i want to be clear or a wingdings tick mark. my scenario is I want to put a tick mark in all cells in column 3 if there is any content in a cell in column 2 and leave column 3 cell blank if cell in column 2 is empty . I want to be able to do this with one clik of a check box and it ticks all of the cells in column 3

kindest regards alex

[davegugg]

Use this in the CheckBox_Click event.

Please Login or Register  to view this content.

[kamikizzy]

Thanks for you input I thought i ought to upload my file so you can see what i am trying to achieve.I need to auto tick column c between c10 and c37

Kindest Regards Alex

[davegugg]

Since you are using a Form Control instead of an activeX control, you'll need to assign the control a macro. First put the code below into a standard module. Then right click the checkbox and click "Assign Macro". Choose the macro you just pasted. Lastly change all the cells from C10 to C37 to Webdings font.

Please Login or Register  to view this content.

[johnjohns]

This is the result of my attempt.

[kamikizzy]

Thank you very much for your input that seems to work perfectly

Kindest regards Alex