Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Muaz Bashara   on Nov 22 In MS Office Category.

  
Question Answered By: Blake Smith   on Nov 22

I missed that bit. I hate those buttons and quickly convert them
to control toolbox ones whenever they appear in stuff I'm working on. :-)

I've just had a bit of a play with a form  button, and I don't think it actually
has a name as such. (Or at least not a visible one.)

What happens is that the button can be associated with a subroutine and you have
the ability both to name this subroutine and to record actions for it. Excel
provides a default  name for this subroutine.

I just created a button and it brought up the assign  macro popup. It wanted to
assign to "Button1_Click". I changed the name of the macro  to "Fred" and then
hit record and recorded some stuff. Once I'd finished the recording, my Module1
VBA module had only a "Fred" subroutine in it.

Similarly, you can change  the name of the subroutine attached to an existing
button. Best way is to create the new subroutine first, then go to the "assign
macro" for the button and you'll see the new subroutine in the list. Select it
and the old identity seems pretty much gone.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Naming of Checkboxes Or get search suggestion and latest updates.


Tagged: