compare 2 mem variables against a string value
 

Hey,
Can anyone help here...

If Mdl = "ZDX" Then 'Works fine
If Mdl or Mdl2 = "ZDX" Then 'Generates Type mismatch error

Does anyone know how to check more than one memory variable (Mdl and Mdl2)
against a string value?

Thanks,
RR

compare 2 mem variables against a string value
 

Try this

If Mdl="ZDX" or Mdl2 = "ZDX" Then
--
If this helps, please remember to click yes.


"Ron5440" wrote:

Hey,
Can anyone help here...

If Mdl = "ZDX" Then 'Works fine
If Mdl or Mdl2 = "ZDX" Then 'Generates Type mismatch error

Does anyone know how to check more than one memory variable (Mdl and Mdl2)
against a string value?

Thanks,
RR

compare 2 mem variables against a string value
 

Hi,

The correct syntax is

If Mdl = "ZDX" Or Mdl2 = "ZDX" Then

Mike

"Ron5440" wrote:

Hey,
Can anyone help here...

If Mdl = "ZDX" Then 'Works fine
If Mdl or Mdl2 = "ZDX" Then 'Generates Type mismatch error

Does anyone know how to check more than one memory variable (Mdl and Mdl2)
against a string value?

Thanks,
RR

compare 2 mem variables against a string value
 

I made this same mistake when I was beginning to learn VBA. This is the way
to do it:

If Mdl = "ZDX" OR Mdl = "ZDX" Then
' do something
End if

Hope this helps! If so, click "YES" below.
--
Cheers,
Ryan


"Ron5440" wrote:

Hey,
Can anyone help here...

If Mdl = "ZDX" Then 'Works fine
If Mdl or Mdl2 = "ZDX" Then 'Generates Type mismatch error

Does anyone know how to check more than one memory variable (Mdl and Mdl2)
against a string value?

Thanks,
RR