Button caption changing depending on macro and current state

Been playing around with this code for an hr now and cant get my head around it, The code works however when you start out, the button is already called Anounced but does not run the macro untill you click it to do Unanounced and then click it back a second time to display anounced and run that coresponding macro.

Is there a way to:

a) Make it run atleast once which ever state the button is in? caption "Anounced" or Caption "Unannounced" so that atleast once when file is loaded it will run so caption shown will have atleast had that macro ran atleast once?

And

b) add a type of start caption, (3rd caption) for example "SELECT" which if a) is working would run Macro3 "SELECT" atleast once on load up and allow the "Anounced" and "Unanounced" to be selected?


(this code was borrowed from somebody else but i can not recall which post it was from as visited lots of sites)

Please Login or Register  to view this content.

any help appreciated.

Originally Posted by MarvinP

Hi Darkprophecy,

How about doing an event macro behind the Worksheet Activate event? Something like:

Please Login or Register  to view this content.

I dont know how these work a snever used them before.

No sure how to implement this?

essentialy i have a button and i press it to run macro to enter some text in a cell if i press it again it enters difrent text in the same cell.
When 1st opening the book the caption for the 1st macro is diplayed but without having run that macro call function for the 1st time.

to get the macro to call i have to cycle through button captions because on loading its a blank cell. (this is why i was wondering if its possible to have a 3rd caption added to this code also. or even just ensure that on loading book it runs by default the macro assigned to the caption atleast once on load up.