Picture

Home Search Site Map

Up
Cells...
Chart...
Columns
Comment
Diagram...
Function...
Hyperlink...
Name
Object...
Page Break
Picture
Rows
Symbol...
Worksheet

New! Excel User Group Now Open @ www.excelusergroup.org,

Menu command Type What happens next?
Picture

Has a submenu detailing all the types of image or picture that can be inserted into Excel. Most of the options, shown right are self-explanatory, but for the sake of completeness we list them here.

  1. Clip Art... - Fires the clip-art 'task pane'. This will list clip art on your machine (if installed with Excel) and if you are online, clipart and images, etc from Microsoft's clip art gallery.

  2. From File... - Shows the standard file dialog allowing you to select any images, locally, on a network or the internet.

  3. From Scanner or Camera... - Connects you via the Scanner/Camera wizard to download pictures from connected devices.

  4. Autoshapes - Shows the Autoshapes toolbar to make a selection from a huge array of call outs, lines, arrows, shapes, etc

  5. WordArt - Launches the WordArt Gallery to create sizeable, customisable text shapes.

  6. Organisation Chart - Places a default organisation chart on the worksheet and launches a complimentary toolbar allowing you to build charts similar to Visio.

VBA Sub AddPic()
Dim wks As Worksheet
Set wks = ActiveSheet
wks.Shapes.AddPicture "C:\Nickh.jpg", msoFalse, msoCTrue, _
100, 100, 80, 100
End Sub

Top

 

Copyright Nick Hodge 2009. All Rights Reserved.