key command

  • Thread starter Thread starter Dale 5484
  • Start date Start date
D

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