Results 1 to 4 of 4

Thread: Text and Data reference formula in a text box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular willow1985's Avatar
    Join Date
    Jul 2019
    Location
    Winnipeg, MB
    Posts
    221
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Text and Data reference formula in a text box

    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

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,590
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Text and Data reference formula in a text box

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

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  3. #3
    Board Regular willow1985's Avatar
    Join Date
    Jul 2019
    Location
    Winnipeg, MB
    Posts
    221
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Text and Data reference formula in a text box

    This works. Thank you very much

  4. #4
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,590
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Text and Data reference formula in a text box

    Quote Originally Posted by willow1985 View Post
    This works. Thank you very much
    You are welcome - thanks for the reply.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •