Add buttons to a sheet with picture or icon

[Zeiler]

I've made a macro which adds different buttons to my sheet.
How can I change the button.caption to a picture instead of text?

Thanks in advance
Willy

[col12345]

Hi Zeller

while in design mode right click on the button and choose properties from the drop down menu.

The list of fields includes picture, if you click in this you can add a picture from file, other options to zoom the picture etc are also there.

hope this helps

cheers

col

[Leith Ross]

Hello Zeiler,

Welcome to the Forum!

Provided your control is an ActiveX control (Control Toolbox) you can also change the Picture through code. You can load the picture from a file like this...

Please Login or Register  to view this content.

The example above assumes the ActiveX control is named "CommandButton1" and is located on the worksheet named "Sheet1". Use the PicturePosition property to position the picture on the control relative to the caption.