change of button properties upon activation

  • Thread starter Thread starter Jos reulen
  • Start date Start date
J

Jos reulen

I use selfmade buttons in excel linked to execution of a
macro. I would like to change properties of the button
upon activation for example a change of background color
or a change of the button image (crying face into laughing
face). How?
Furthermore, in Excel I have a limited number of figures
available to use as image in a button to which a macro
execution is coupled. how can i insert different figures
of all kind in a button ?

thank you
jos reulen
 
What kind of button

On the worksheet you could use a button from the Forms Toolbar or a
commandbutton from the Control toolbox toolbar. If you are talking about
menus, then you would be using a commandbarbutton.

In a commandbarbutton, the background color is controlled by windows. Don't
believe you can change that. Same for a forms button, but you can change it
for a Commandbutton. Just put the code to change it in the event.

For a commandbarbutton you can get your picture in the clipboard, then use
the pasteface method. In a commandbutton, you have a picture property you
can set to the name of a file.
 
Back
Top