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

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



kirkm wrote:

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

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!
--
Gary's Student
gsnu200709


"kirkm" wrote:


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

On Sat, 10 Mar 2007 08:34:58 -0600, Dave Peterson
wrote:

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

On Sat, 10 Mar 2007 14:15:00 -0800, Gary''s Student
wrote:

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

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...

"kirkm" wrote:


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