View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default how to apply button text from macro?

Greetings and TIA for your time
Button1 triggers Macro1. Macro1 has code to change the text on Button1
Using a button from the 'forms' toolbar
I've tried:ActiveSheet.Shapes("Button 1").Characters.Text = "NewText" -
which fails.
What code should I use?
David