Text and Data reference formula in a text box

[willow1985]

I am trying to put the following formula in a text box

="Total: " & Data!B8

But I keep getting the following error:

"The formula is missing a range reference or a defined name."

Could anyone tell me what I am missing? I thought this was pretty straight forward.....

Thank you

Carla

 

[JoeMo]

You can only reference the cell like that, but if the value of Data!B8 is x you change cell Data!B8 to this: ="Total: "&x, then with your text box selected press F2 key and type: =Data!B8 and press Enter.

 

[willow1985]

This works. Thank you very much

 

[JoeMo]

This works. Thank you very much

You are welcome - thanks for the reply.