CStr Question

**dugong** · 05-20-2008, 06:36 AM

Hi

I am learning Excel VBA (teaching myself and not being very good at it).

I have a query on CStr - in the example below, it is used for the Msgbox - but when I put the second MsgBox line in (as I couldn't see why it is needed in the example), it returns the same result.

Please Login or Register  to view this content.

So my question is - why/what example would you use it..????

Can someone explain it to me..(in laymans/simple terms please as i am not a computer techie!)?

Thanks, dugong

p.s. I have looked at the help and it does not explain it satisfactorily either!

**Andy Pope** · 05-20-2008, 06:57 AM

You would use it to convert a variable or constant to String type.

What may appear confusing is that the msgbox function works the same regardless of your use of the CSTR funciton. This is because VBA conveniently does the conversion for you automatically.

By using it you are telling the compiler exactly what you want to happen rather than letting it make assumptions.
This also makes the intention clearer when you or somebody else reviews the code at a later date.