title: Excel VBA Set a Commandbutton Caption from a Userform Textbox
body: <p>I have a button that is on an excel spreadsheet (not in a userform) and I have a userfrom that has a textbox on and would like it to, when I enter a name in the textbox on my userform for it to then set the Caption of my button that is on my excel sheet to what ever is entered in the textbox. I would like to know what code I need to use and where to insert that code?</p>
  
  <p>Hope that make sense, please keep in mind I'm a newbie to this so this is why I am asking where to insert the code</p>
  
  <p>Many thanks in advance</p>