key command


Dale 5484

I'm trying to set up a form what I would like to use is a keystroke to insert
a graphic or clipart. Any suggestions on where to start? I'm using student
edition 2007 Excel



Gary''s Student

This macro will insert a given picture:

Sub Macro1()
ActiveSheet.Pictures.Insert ("C:\flower.jpg")
End Sub

You can assign a shortcut key to it. If yuo want the user to select the
picture, then modify the macro to open the appropriate DialogBox.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question