Text displayed on a button Excel Macro
<p>How do or is it possible to have a button assigned to a Macro and have the text of such button be a formula?</p>

<p>i.e </p>

<p>If A2 is "John Doe"</p>

<p>Can the button have John Doe as the text??? and If I change the name to "Jane Doe" have a formula (=A2) so that when Ichange the text the display text of the button change automatically???</p>