what do you mean by'assign a specific (hidden) cell to that shape'?
You may also want to hide the row/ column which is assigned to this shape as it is probably not needed for the average user or viewerwhat do you mean by'assign a specific (hidden) cell to that shape'?
Yes that is what i mean. Sorry i am terrible about explaining things, but im working on it.I believe he means. Click on your shape then click in the formula bar and put in "=A1" and then what ever text in placed in A1 will now show up in your shape.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
Do this
End sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
Do this
End if
If Target.Address = Range("A2").Address Then
Do this
end if
If Target.Address = Range("A3").Address Then
Do this
end if
End sub