Resolved:Wheres Waldo (or the problem :p)

[d22k]

If ComboInLabel.Caption = "Centimeters (Cm)" Or "Meters (M)" Or "Kilometers (Km)" Then
CompatabilityInType = "Length"
End If

Im getting a type mismatch error, im guessing that IF cannot handle 'or' with strings? only numbers?

thanks in advance

[demotivater]

If ComboInLabel.Caption = "Centimeters (Cm)" Or ComboInLabel.Caption = "Centimeters (Cm)" 'etc

You have to add the ComboInLable.Caption = after your Or

[RhinoBull]

... or use Select Case syntax instead:

Select Case ComboInLabel.Caption
    Case "Centimeters (Cm)"
        '...
    Case "Meters (M)"
        '...
    Case "Kilometers (Km)"
        '...
End Select
 
'OR
 
Select Case ComboInLabel.Caption
    Case "Centimeters (Cm)", "Meters (M)", "Kilometers (Km)"
        '...
End Select

[d22k]

thanks both of you,
especially rhino (yet again )

I wanted to use Case, however when i had tried it i had the synatx wrong, i had the Case of in brackets....

anyways cheers

[epod69]

Do they make those books anymore?

[RhinoBull]

Do they make those books anymore?

I can write one for you ...

[RhinoBull]

thanks both of you,
especially rhino (yet again )

I wanted to use Case, however when i had tried it i had the synatx wrong, i had the Case of in brackets....

anyways cheers

[epod69]

I can write one for you ...

Well if it was anything like the books I read (well umm seen), I think it would take you a few days to do so =P