I need a macro to assign to an object button (Shape) when pressed it will toggle a specific cell value to change between PLANNED, IN-BUILD and COMPLETE. I have this code but it only gives me two options Any Help would be appreciated.
Regards
Jason Bing
Private Sub CommandButton1_Click()
With...