How can I use CHAR() function in VB?

Hiya,

I want to convert a number to it's character value within a VB variable in
Excel - this can be done using CHAR() within the worksheet - eg CHAR(66)
results in "B".

CHAR() doesn't seem to work in VB - does anyone know how I can do it? I need
it to populate a variable using an integer, i, which I increase by 1 in each
iteration of a loop.

Thanks!

Basil

Hi Basil,

Basil wrote:
> I want to convert a number to it's character value within a VB
> variable in Excel - this can be done using CHAR() within the
> worksheet - eg CHAR(66) results in "B".
>
> CHAR() doesn't seem to work in VB - does anyone know how I can do it?
> I need it to populate a variable using an integer, i, which I
> increase by 1 in each iteration of a loop.

The VBA equivalent of the CHAR() worksheet function is Chr().

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Hi,
In vba, it is CHR( )
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Basil" wrote:

> Hiya,
>
> I want to convert a number to it's character value within a VB variable in
> Excel - this can be done using CHAR() within the worksheet - eg CHAR(66)
> results in "B".
>
> CHAR() doesn't seem to work in VB - does anyone know how I can do it? I need
> it to populate a variable using an integer, i, which I increase by 1 in each
> iteration of a loop.
>
> Thanks!
>
> Basil