Assigning a Value to a CheckBox in Excel VBA Userform

Discussion in 'The Guru's Pub' started by (.)(.), May 12, 2014.

  1. (.)(.)

    (.)(.) Banned

    Likes Received:
    GTX 970
    Does anyone know how to assign a value (eg: 100) to a CheckBox in Excel VBA.

    When CheckBoxes are checked in a userform created via vba eg:
    CheckBox1 = 100
    CheckBox2 = 50

    The total is added up at the end using 'Private Sub CheckBox1_Click()' (Calculate command button) and outputs the total into the label 'Total' eg: 'Total.Caption = CheckBox1 + CheckBox2'

    Make sense?

    Thanks for any help.

    Edit: NVM all sorted.
    Last edited: May 12, 2014

Share This Page