View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SupperDuck SupperDuck is offline
external usenet poster
 
Posts: 44
Default Converting doubles to text ot string

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