Display a TextBox in a Picture based on the value in a cell

[PeterMac65]

Hi,
I know i can show the contents of a textBox in a picture by Naming the Cell and referring to that name in the picture.
eg =Payment_terms


But i have 2 textBoxes that i wish to choose from.
eg =IF(contract_type="TurnKey Contract", TurnKey_Contract, StandardMB_Contract)

I can't do this in the Picture formula, but can i do something with the Text Boxes? Preferably without VBA

Regards Peter

 

[Craggs82]

Hi Peter,

you could add that formula to a new named range, then reference that new named range in the picture/shape so it would update dynamically.

 

[PeterMac65]

Thanks Craggs82,
I couldn't figure how to make your suggestion work.

So I resorted to VBA
Public Sub Worksheet_Activate()
If ActiveWorkbook.Sheets("Data").Range("contract_type").Value = "TurnKey Contract" Then
ActiveSheet.Shapes.Range(Array("bring_picture")).Visible = msoTrue
Else
ActiveSheet.Shapes.Range(Array("bring_picture")).Visible = msoFalse
End If
End Sub

If your way works feel free to add more detail
Regards Peter