Compare string with integer

I am using excel 2002. I want to compare a string variable with an integer variable. i.e.

dim i as integer
i=1
dim s as string
s="1"
if i = s then
...........
else
......
end if

however, when I run this macro, a error occur.
how should I compare the variable with two different format ?

You have to "coerce" the data in one type to that of the other. Look up
"coerce" in VBA Help for the various Cxxx function.

NickHK

"hurriance" <[email protected]> wrote
in message news:[email protected]...
>
> I am using excel 2002. I want to compare a string variable with an
> integer variable. i.e.
>
> dim i as integer
> i=1
> dim s as string
> s="1"
> if i = s then
> ..........
> else
> .....
> end if
>
> however, when I run this macro, a error occur.
> how should I compare the variable with two different format ?
>
>
> --
> hurriance
> ------------------------------------------------------------------------
> hurriance's Profile:
http://www.excelforum.com/member.php...o&userid=30882
> View this thread: http://www.excelforum.com/showthread...hreadid=555450
>

doesn't that code work as you want?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"hurriance" <[email protected]> wrote
in message news:[email protected]...
>
> I am using excel 2002. I want to compare a string variable with an
> integer variable. i.e.
>
> dim i as integer
> i=1
> dim s as string
> s="1"
> if i = s then
> ..........
> else
> .....
> end if
>
> however, when I run this macro, a error occur.
> how should I compare the variable with two different format ?
>
>
> --
> hurriance
> ------------------------------------------------------------------------
> hurriance's Profile:
http://www.excelforum.com/member.php...o&userid=30882
> View this thread: http://www.excelforum.com/showthread...hreadid=555450
>