how can I activate a formula if checkbox is checked

hello everybody, I have this checkbox on my userform. When I check it I would like a formula on my worksheet to be activated, if it is not checked then the value in the cell should be "N/A"

This is the formula in my form!G19

Please Login or Register  to view this content.

Any suggestions?

Thank you for any help

Hi,

One way to do what you want is to use an auxiliary cell on the Workbook ('H19' for example).
When you Check the CheckBox on the UserForm put 'X' in cell 'H19', otherwise leave cell 'H19' blank.

Change your formula:

Formula:

Please Login or Register  to view this content.

Lewis

hello Lewis, it works.

Thank you very much for your help