Image on Connand Button

[kirkm]

I'd like to add three buttons to a form and have them show as icons.
They're Notepad, Clipboard, and Playlist (which may not exist).

Where are these .ico files found, and can they be used as the picture
source, or must they be converted to jpg's ?

Thanks - Kirk

 

[Dave Peterson]

Icons are all over the place--sometimes, they're buried in the .exe (or .dll).

If you go to google and search for "icon extractor", you'll find lots of hits.

(I don't know if they'll work as .ico files--but it won't take too long for you
to test it and if it fails, convert it to something that works.)

David McRitchie has some links:
http://www.mvps.org/dmcritchie/excel/toolbars.htm#ico

 

[Gary''s Student]

An alternative is to use a picture as a button. ClipArt for example.

Use Insert > Picture and put some clipart on a worksheet. If you
right-click the picture, you will find you can assign a macro to the picture!

 

[kirkm]

Icons are all over the place--sometimes, they're buried in the .exe (or .dll).

If you go to google and search for "icon extractor", you'll find lots of hits.

Thank you. Found one - works great!

Cheers - Kirk

 

[kirkm]

An alternative is to use a picture as a button. ClipArt for example.

Use Insert > Picture and put some clipart on a worksheet. If you
right-click the picture, you will find you can assign a macro to the picture!

It's required on a Form, where I don't see an Insert-Picture option.

I can use the Image property and convert to ico to jpg.
Unless you have a better idea?

Thanks - Kirk

 

[Badrul]

Hi,
Try this. Once you create a command button in the form (in VBA editor of
course), edit the Properties of the button. Look at the Picture... and
PicturePosition properties. This can help you.

This method is also applied to Sheet, if you create the button on the
sheet...