电子表格未返回简单值

Question

If ActiveSheet.Cells(myRow, 3).Value = "" Then
    APCtext = "" & APC = 2
ElseIf ActiveSheet.Cells(myRow, 3).Value = "?" Then
    APCtext = "Unknown" & APC = 3
Else
    APCtext = ActiveSheet.Cells(myRow, 3).Value & APC = 1
End If

这应该得到的第一个值不是空的或问号，但它不会在 else 部分中返回此值。任何人都可以指出这段代码有什么问题吗？

Answer 1

试试这个：

If ActiveSheet.Cells(myRow, 3).Value = "" Then
    APCtext = ""
    APC = 2
ElseIf ActiveSheet.Cells(myRow, 3).Value = "?" Then
    APCtext = "Unknown"
    APC = 3
Else
    APCtext = ActiveSheet.Cells(myRow, 3).Value
    APC = 1
End If