
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
"Joseph Carrier" wrote... .. > . . . That involves >clicking on Create|Button, creating, placing (and naming) a button on >a sheet, and then invoking "IDE" to create a simple Button|Click >subroutine. Creating the Button|Click subroutine supposedly involves >only the insertion of the name of the (separate, global) subroutine in >the Button|Click subroutine, as follows: > >sub > (name of subroutine to be run on click) >end sub > >That works perfectly in the tutorial. When I follow the exact same >procedure, step-by-step, for one of my own worksheets, I keep running >into the error message that the name of the (seperate, global) sub >that I insert in the Button|Click subroutine is not a subroutine or >function name. I've tried this several times and checked carefully to >be sure that the Global subroutine whose name I use in the >Button|Click sub does indded exist, is listed among the Global script >subroutines, and has been stored with the worksheet. .. Show the *EXACT* and *COMPLETE* text of your Click event handler script. The following works for me without any problems. In (Globals) ------------ Sub bar Msgbox "foobar" End Sub In fooButton ------------ Sub Click(Source As Buttoncontrol) foobar End Sub -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives.
| <-- __Chronological__ --> | <-- __Thread__ --> |