Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
EMMY NOMINATED SERIES directed by and starring Steve Buscemi is back for a second season!!! Park Bench is a local's take on the special people, places, and spirit of New York City. Through unscripted moments with average New Yorkers and Steve's celeb friends, Buscemi takes viewers on a funny, first-hand journey/misadventure, told in his unique voice.
Journey to the Draft is an organic, unscripted, docu-series that follows three college football players, all with promising professional careers. These young men attend different schools across the country and play a variety of positions on the field, but at the end of the day they share one goal:to play in the NFL. The AOL docu-series follows players Leonard Williams, Kevin White and Marcus Peters.
Connected features the personal stories of six New Yorkers woven together into one of the most intimate series ever. This groundbreaking show changes the nature of storytelling by giving each character a camera to document their lives. The result is a unique format revealing as different as everyone appears to be, we are all universally Connected.
Wake up to your world in 2 minutes.
"Stricly Come Dancing presenter Tess Daly and The Saturdays' Rochelle Humes talk to mums about their experiences of being mum. Whether the daughter of a Rolling Stone, in one of the most famous girl bands the world has ever known, or a parent coping with disability as well as family life, each mother in Being Mum shows that the feelings, challenges and rewards of motherhood are universal no matter the surroundings you find yourself in."
Jews and Money. Asian Drivers. Polish IQ. CPT… that's racist! But where do these stereotypes come from? Comedian Mike Epps explores the backstories of this humor and how history and fact often distorts into a snide – but sometimes funny – shorthand.
"INSPIRED" features celebrities, visionaries and some of the biggest newsmakers of our generation, recounting the stories behind their biggest, life-changing moments of inspiration.
In a compelling series of verite encounters, Win Win provides unique access into the minds and lives of the world’s most-celebrated entrepreneurs and athletes.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Comedy is hard, but teaching comedy to children is hilariously difficult. Kevin Nealon is giving the challenge to some world-famous comedians. As these young minds meet with comedy’s best, get ready to learn some valuable comedy lessons, and to laugh!
James Franco loves movies. He loves watching them, acting in them, directing them, and even writing them. And now, he’s going to take some of his favorite movie scenes from the most famous films of all time, and re-imagine them in ways that only James can.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
In the Excel spredsheet tutorial learn how to add popups to individual cells.
Tags:How to Add Pop Up Pictures to an Excel Cell,add pictures to excel,excel advice,excel pictures,excel spreadsheets,Excel tips,How to add Pop Up Pictures to a Cell,MrExcel
Grab video code:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen. Basically you start out with massive amounts of data, say how you're going to analyze this. Well, let's fire up the pivot table and see if we can solve this problem.
All right, welcome back to the MrExcel netcast. I'm Bill Jelen. Today’s question from John talking about episode 322, isn’t that a long time ago where I showed how to add a comment that has a pop-up picture in a cell. John says, “Hey, I have a whole bunch of this I have to do. Very tedious to do at one at a time can we do a macro?” Well, I tried that. I turned on the macro recorder and said add pics recorded and I went through the steps to add a picture to one cell so that’s a new comment. Backspace through the text, choose the comment and then control one to format and then we come here, colors in lines. Hoping this drop down up to use fill effects or we choose picture, all right select picture now.
For this particular application all of this SKU’s have a picture in a particular folder. So it’s under sequel and Q image and then its starts with QI in the SKU. So j45271, bingo, there it is, click insert. Click okay, click okay and we’ll click away and now I can stop recording and you’ll see how this works now when I hover over the red triangle the picture pops up, very cool right.
Well, let's go take a look at that coat. We’ll come back here to develop our tab, visual basic and wow they record a lot of stuff here. There is the add comment and then they go through and change the font which is kind of silly because I got rid of all of that text and then use selection.shaperange.fill.userpicture, there we go. We’ve got now an interesting thing here and that’s the recorded code. I actually went back to the book “Learn Excel”, 97 through 2010 for MrExcel and out of 377 tips on this book there is VBA and exactly one tip and it’s the VBA that shows how to solve this problem. The code that is in the book is much simpler than the recorded code
Okay, for each cell in selection we’re going to select the range of SKU’s, figure out what the picture is and here’s where I have hard coded. It sequel and back slash my folder name, my prefix QI and cut made in the SKU and then finally .jpeg at the end, very simple with cell. Cell is an object variable as we go through each item in the selection. I'm on an object variable called cell.addcomment and then the .shape not shape range.fill.userpicture and there is our variable.
So let's give it a try, we’ll come back here and we’ll select the rest of the SKU’s. We’ll run that code. So macros add pics, click run, look how fast that was, added red triangles through out. As we hover we can see the picture for each individual SKU, isn’t that cool? Hey John, great question, luckily that one was in the book. So we’ll send you back for anyone who wants to see how to add one to episode 322 where we went through probably a bit slower and then for anyone who wants to see how to do that of course the add pics and by the way, guess I haven’t mentioned that you can always download that book for free. Now just go to MrExcel.com/previewSIG.html and now you can take a look at the book and figure out if you like it or not.
If you like it, go out and buy it, if you don’t what do you lose 60 seconds to download the whole book. Hey, I want to thank you for stopping by and we’ll see you next time for another netcast from MrExcel.