Good Morning,
I have the code below that gives me an error when a blank cell in the dropdown list is chosen. Excel is Office 365
Public Function cellValidation(cellValue As Variant)
If cellValue = 3 Or cellValue = 12 Or cellValue = 15 Or cellValue = 48 Or cellValue = 51 Or cellValue = 60 Then
cellValidation = 1
Else
cellValidation = 0
End If
End Function
The list associated with this has some 5 blank cells to allow for possible expansion. When I use the combobox to change a value on the list it works fine. However, when I choose a blank cell I get an error with the line above in the red text. Run-time error '13': Type Mismatch I tried adding Or cellValue= "" I've also tried Empty , Null, Error and Nothing but that didn't work.
Any help would be greatly appreciated.
Thanks
I have the code below that gives me an error when a blank cell in the dropdown list is chosen. Excel is Office 365
Public Function cellValidation(cellValue As Variant)
If cellValue = 3 Or cellValue = 12 Or cellValue = 15 Or cellValue = 48 Or cellValue = 51 Or cellValue = 60 Then
cellValidation = 1
Else
cellValidation = 0
End If
End Function
The list associated with this has some 5 blank cells to allow for possible expansion. When I use the combobox to change a value on the list it works fine. However, when I choose a blank cell I get an error with the line above in the red text. Run-time error '13': Type Mismatch I tried adding Or cellValue= "" I've also tried Empty , Null, Error and Nothing but that didn't work.
Any help would be greatly appreciated.
Thanks