multiply command to checkbox icon

[Lacostee12]

Dear members and administrators,

I should get macro that multiply (double) ´with 2 one cell value after i click its Value = True and undo that when value = False. Idea sounds easy but i wont get it. Problem is because first i have to insert value by manually and after that made a selection does that multiply it or not. So value is not solid and it can vary.

I have workbook added here. I think this is easy for you guys but could you please help me newbie Thank you very much.

BR,
Ville

Ps. I'm using excel 2003.

[joseph4tw]

Hello,

Go to the developer tab, click "Design Mode" to activate design mode, right-click the checkbox and click "View Code." Then add this code:

Private Sub CheckBox1_Click()
    If (CheckBox1.Value = True) Then
        Range("D5").Value = Range("D5").Value * 2
    Else
        Range("D5").Value = Range("D5").Value / 2
    End If
End Sub

Then go back to the developer tab, click "Design Mode" to deactivate design mode.

Hope this helps.

[Lacostee12]

Yes this works! Thank you very much!!

[joseph4tw]

You're welcome