stiffrimpet
New Member
- Joined
- Apr 10, 2002
- Messages
- 10
I'm not sure if this is possible but I'll ask anyhoo.
I have this code:
---
Private Sub CalcButton_Click()
If CostBox.Value = "?" Then
MsgBox ("Invalid Cost")
CostBox.Value = ""
Else
If CostBox.Value = "?" Then
a = CostBox.Value
b = QuantityBox.Value
answer = a * b
SubCostBox.Text = answer
End If
End If
End Sub
---
The question marks are the problem. I need CostBox.Value to be any number but NOT a letter. Are there any wildcards I could use, one for letters and one for numbers?
Any help or put-downs at my gross incompetence would be much appreciated!
stiffrimpet
I have this code:
---
Private Sub CalcButton_Click()
If CostBox.Value = "?" Then
MsgBox ("Invalid Cost")
CostBox.Value = ""
Else
If CostBox.Value = "?" Then
a = CostBox.Value
b = QuantityBox.Value
answer = a * b
SubCostBox.Text = answer
End If
End If
End Sub
---
The question marks are the problem. I need CostBox.Value to be any number but NOT a letter. Are there any wildcards I could use, one for letters and one for numbers?
Any help or put-downs at my gross incompetence would be much appreciated!
stiffrimpet