I would like to enter a value in a cell (eg. 999) and have a textbox automatically update with "The result is $999".
I would like to enter a value in a cell (eg. 999) and have a textbox automatically update with "The result is $999".
Any chance you could just hide a cell with "The result is" somewhere in your workbook and then use the ampersand to reference the two cells to make your statement?
Thanks, but the text in the textbox is a formatted paragraph and I would prefer this be in a textbox.
In another cell (I chose J1) enter ="The result is "&A1
In the text box change your reference to =J1
If you want the $ sign enter in J1 ="The result is $"&A1
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
That's a good point, however I want to be able to easily format the text box paragraph.
A temporary solution is to move one text box over the other, however this isn't optimal.
Could you possibly use merged cells like in this example as you are finding out quickly the limitations of text boxes. I tried text in a shape but that was a disaster.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks