Insert picture in CommandButton (ActiveX control)

[antaeusguy]

I've inserted an ActiveX control, a CommandButton in my worksheet.

Usually, in design mode, I open the properties and change it's caption value to make the CommandButton display the function, e.g. in my case I put as "Search".

I have a magnifying glass picture and would like to insert it into the CommandButton. I like to do this because I want to get the "pressed down" effect of the CommandButton.

If I insert the picture as an object and assign a macro to it, I can't seem to make it "sunk" when clicked like how the CommandButton does...

Does anyone have any suggestion on this, would be much appreciated.

 

[Ruddles]

I'm not sure why you're inserting the picture as an object. If you do that, I think you'd need a second picture which was a 'sunken' version of the first one, and which you'd swap it in when the control was clicked and swap out again afterwards. That seems like a lot of trouble to me.

If you already have a button, just set its Picture property to point to your graphic file, then it will sink when it's clicked.

Or at least it does here!