Forum Discussion
Excel TextBox
I have a value in CellA1 - say 10
I have a textbox which says "this month revenue ia $XXXm.
i want to link XXX to value in A1.
I have a textbox which says "this month revenue ia $XXXm.
i want to link XXX to value in A1.
1 Reply
You should create a helping cell with the following formula...
e.g. say in B1, place the following formula...
="This month revenue ia $"&A1&"m"
And then select the TextBox and then click in the formula bar and type =$B$1 and hit Enter.
You may choose the formula cell as per your requirement.
