VBA IF function with checkbox

[Sach1810]

Hi, I would like to create a VBA function in which if a checkbox is checked (say its linked to cell A1 it puts the value of a cell (b2) in cell a3.

Your help would be much appreciated

Thanks

Sacha David

 

[tusharm]

This can be done without VBA. Check out Excel help for the IF function.

 

[Sach1810]

Hi, I need it with VBA for a more complex item I just kept it simple on here and will tweak it after

Thanks

Sacha David

 

[tusharm]

Same thing applies. Check Excel VBA for the If statement. To refer to a cell in row R column C, use cells(r,c).value. So, to refer to cell(10,2), i.e., B10, use cells(10,2).value.

Hi, I need it with VBA for a more complex item I just kept it simple on here and will tweak it after

Thanks

Sacha David