Pasting an object into a cell with a drop down menu

  • Thread starter Thread starter ksgoodwin
  • Start date Start date
K

ksgoodwin

I have made simple Macros to paste objects (Autoshapes) into various
cells.

Sub Macro1()
' Keyboard Shortcut: Ctrl+q
ActiveSheet.Shapes("Group 100").Select
Selection.Copy
ActiveCell.Select
ActiveSheet.Paste
ActiveCell.Select
End Sub

I would like not to use Macros but instead use a Drop Down Menu.

Ideas?

Ken
 
Objects cannot be pasted "into" cells.........only lay on top.

To have a picture show up based on VLOOKUP when you select an item from a DV
list or type in a name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed and the
pictures must be stored on the same worksheet as the VLOOKUP formula.

But that will pose no problem...........simply cut and paste the shapes to
the sheet in which you want them to be displayed.

Or you need multiple pictures shown from VLOOKUPS.............

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures via selections.

Allows for more than one picture to be displayed on a sheet but also
requires the pictures be stored on same sheet.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP
 
Back
Top