Variable Text on a Button

Giganews Newsgroups
Subject: Variable Text on a Button
Posted by:  paulw
Date: Wed, 10 May 2006

For most macros I make, I use a Button, from the Forms taskbar to execute it.

What I want to do is set up a Button that runs 2 macro's, depending on what
was last run. I've done this easily before by setting both scripts in the
same macro, and a simple IF statement to look at a cell that is change at the
end of each macro. An example is it changes from "Automatic" to "Manual" and
this removes or adds forumlas in certain cells.

My question is, can I change the text on the button dependant on cells? So
if A1 is 1, the button says "Automatic" and if A1 is 0 the button reads as
"Manual" ?

Replies