Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default how do i change a picture in a spreadsheet using a macro?

I'm trying to create a spreadsheet that will contain a picture. The problem
is, each user will have their own picture. I'm trying to accomplish this by
putting in a dropdown box that will allow the user to choose their name and
then have their picture appear automatically (based on whatever name they
choose). Is it possible to create a macro to automatically insert the
correct picture based on what's chosen in the dropbox?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how do i change a picture in a spreadsheet using a macro?

Maybe you could do something like JE McGimpsey does at:
http://www.mcgimpsey.com/excel/lookuppics.html

ScottG wrote:

I'm trying to create a spreadsheet that will contain a picture. The problem
is, each user will have their own picture. I'm trying to accomplish this by
putting in a dropdown box that will allow the user to choose their name and
then have their picture appear automatically (based on whatever name they
choose). Is it possible to create a macro to automatically insert the
correct picture based on what's chosen in the dropbox?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Picture to Locked Spreadsheet The Merg Excel Discussion (Misc queries) 0 May 20th 08 09:52 PM
How to use a macro to copy a picture from another spreadsheet brown1scrappy Excel Worksheet Functions 0 December 17th 07 08:22 PM
put a picture in the background of an excel spreadsheet? Kenneth white Excel Discussion (Misc queries) 2 May 15th 07 04:44 PM
How to make a picture appear behind data in a spreadsheet John New Users to Excel 2 November 5th 05 01:35 AM
Inserting picture in an Excel spreadsheet sdipietro Setting up and Configuration of Excel 0 August 29th 05 01:05 AM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"