cypher
11-19-2018, 08:23 PM
I'm new to VBA and have been trying various things for hours but I can't seem to figure out how to simply multiply a decimal user input of 1.1 by the cell value of C1 or C3 (71388.92). Here is what I've tried last:
Private Sub CommandButton1_Click()
Dim myValue As Variant
myValue = InputBox("Prompt", "Title")
Range("C5").Value = myValue * Range("C1")
End Sub
I get a runtime error '13'- Type mismatch because cell C1's value is derived from from json web query. I've tried Variant, Double, Single, Long and Data Types: Decimal, Number and Currency.
Private Sub CommandButton1_Click()
Dim myValue As Variant
myValue = InputBox("Prompt", "Title")
Range("C5").Value = myValue * Range("C1")
End Sub
I get a runtime error '13'- Type mismatch because cell C1's value is derived from from json web query. I've tried Variant, Double, Single, Long and Data Types: Decimal, Number and Currency.