Pasting an object into a cell with a drop down menu

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
 
G

Gord Dibben

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
 

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

Top