TheMatrixReloaded
New Member
- Joined
- May 6, 2002
- Messages
- 29
Here is the code:
With Sheets("Order Table").Range("B" & intcurrentrow)
If lstOrderType = "Delivery" Then
.Value = "Delivery"
ElseIf lstOrderType = "Carry-Out" Then
.Value = "Carry-Out"
Else
.Value = "Eat-In"
End If
End With
The only value i get in the range is Eat-In.
With Sheets("Order Table").Range("B" & intcurrentrow)
If lstOrderType = "Delivery" Then
.Value = "Delivery"
ElseIf lstOrderType = "Carry-Out" Then
.Value = "Carry-Out"
Else
.Value = "Eat-In"
End If
End With
The only value i get in the range is Eat-In.