Converting doubles to text ot string

[Guest]

Hello,

I am getting value from a cell with VBA.

dim a as double

A= cell(1,1).value

And this will be the caption of a label. But when i do this, there is an
error like;

"Type mismatch"

What i guessed is that the label caption must be a text so i must convert it
into string or text, right?

If yes, how? If no? what can i do?

thanks...

 

[Tim]

dim A as String
A= Cstr(cell(1,1).value)


Tim

 

[Guest]

try this:-

Sub jugation()
Dim a As Double
a = Cells(1, 1).Value
b = CStr(a)
End Sub

Mike

 

[Guest]

Thanks.

dim A as String
A= Cstr(cell(1,1).value)


Tim