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...

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


Tim

"SupperDuck" <(E-Mail Removed)> wrote in message
news:AB74F1FE-D436-4FAD-B8B8-(E-Mail Removed)...
> 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...

try this:-

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

Mike

"SupperDuck" wrote:

> 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...

Thanks.

"Tim" wrote:

> dim A as String
> A= Cstr(cell(1,1).value)
>
>
> Tim
>
> "SupperDuck" <(E-Mail Removed)> wrote in message
> news:AB74F1FE-D436-4FAD-B8B8-(E-Mail Removed)...
> > 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...
>
>
>