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.