help with vb code to return the value of the cell to the right of the checkbox

Hi all

I was wondering whether someone can help me with the following

I have a worksheet with lots of check boxes.

I have a code which looks at which checkbox is checked. This is a form control check box and not active x.

What I need is if the check box is checked then to return the value of the cell which is two rows after the checkbox.

my current code is

Please Login or Register  to view this content.

i placed a check box in B13. so of this checkbox its ticked i need the value of the cell d13.

thanks in advance

Use something like this for the basis of your code:-

Please Login or Register  to view this content.

This code worked fine. Thak you for your help.

You're welcome