How to Calculate userform textbox and cell Value for label caption

How to calculate userform textbox and cell Value for label caption

Requirement:

The user has a Userform that has multiple textboxes, comboboxes, and labels.

The user is attempting to do for this part is to look at a sheet Value, 2 comboboxes and a text box.

The user would like to make it do in plain terms is: "If combobox1 says "Small" AND combobox2 says "Wash", get the value of cell E1 from the sheet named "DATA", and calculate it with the input of textbox1. so if the condition are met, "Small" and "Wash" then $30 X 1 =$30. Respectively me.cbsize, me.cbservice, E1 .value, me.tbQty, Me.lblPrice1.

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1201565-calculate-userform-textbox-and-cell-value-for-label-caption

Solution:

Code:

Private Sub cbsize_Change()
    Call Price
End Sub

Private Sub cbservice_Change()
    Call Price
End Sub

Private Sub tbQty_AfterUpdate()
    Call Price
End Sub

Private Sub Price()
    If cbsize = "Small" And cbservice = "Wash" And tbQty <> "" Then
        lblprice.Caption = "$" & Format(Sheets("DATA").[e1] * CDbl(tbQty), "0.00")
    Else
        lblprice.Caption =""
    End If
End Sub

Obtained from the OzGrid Help Forum.

Solution provided by KjBox.