Using VBA to find find/copy/paste/position named pictures based on cell values

sputnix

New Member
Joined
Oct 2, 2014
Messages
1
Hi!

Im new to VBA and im doing this little project to get try it out, but no matter how much i google/read about it i cant seem to figure this out. Here is what im trying to do:

I have a spreadsheet where i want to fill in stats from hockey games, who played and whats the score. In two colums i have made lists (data validation) containing all the teams in the league and what i want is the team logo to appear in the cells next to the cell with the team name. Alle the logos are placed on a different worksheet (2), the imagefiles are sized so they fit within the cells in the column they are in. I want to make a makro that searches through the coloumns on where i have the team names (worksheet 1) and when it finds a cell with a team name in it, it will copy the teamlogo (named picture) from the other worksheet, and paste it in the center of the cell next to the name. I want this makro to detect automatically when cells in the "team columns" have been changed (not empty) such that team logos appear right away.

I would be incredibly thankful for any help!
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,108,510
Messages
5,523,318
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top