I want to use the value in a text box in a calculation for a Select Case statement in VBA. The code i am trying to use is:

Case "-----"
Text75 = (cboQuantity)*(cboUnitPrice)*(txtWidth)

The calculation works untill i put the txtwidth on the end. Have i missed something out?

shot in the dark try Val(txtWidth)