Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung

Dim sVal as string

sVal = Right("ABC",1)

sVal = Format(123, "0.00")


as examples

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leung" wrote in message
...
Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung

If you are getting an error, go to tools=references and make sure that you
don't have a reference shown as MISSING. If you do, this is the cause of the
error. Correct the reference (remove it if you don't need it).

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote:

Dim sVal as string

sVal = Right("ABC",1)

sVal = Format(123, "0.00")


as examples

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leung" wrote in message
...
Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung

Tom

Thanks a lot

I thought the reason is because excel97 can't use Right and Format Function..

But actualy it is missing the WordDLL as reference.



"Tom Ogilvy" wrote:

If you are getting an error, go to tools=references and make sure that you
don't have a reference shown as MISSING. If you do, this is the cause of the
error. Correct the reference (remove it if you don't need it).

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote:

Dim sVal as string

sVal = Right("ABC",1)

sVal = Format(123, "0.00")


as examples

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leung" wrote in message
...
Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung