Excel - Adding a Pop-Up Picture to an Excel cell using VBA - Episode 1386
Microsoft Excel Tutorial: VBA Picture Comments in Excel: How to Add Pop-Up Pictures using VBA Code | MrExcel Podcast.
Welcome back to the MrExcel podcast. In this episode, we will be discussing VBA Picture Comments in Excel. This topic may sound familiar to some of you who have been following my work since my days as a regular guest on Call for Help on Tech TV. However, with the changes in Excel 2010, the code we used to use for this feature is no longer working. So, let's dive into how to add these pop-up pictures using VBA in Excel 2010.
First, let's go over the steps for manually adding a picture comment in Excel. You have to insert a comment, delete all the text in the comment, change the diagonal lines to dots, and then format the comment to add a picture. This can be a tedious process, especially if you have a large number of items to add picture comments to. That's where VBA comes in to save the day.
In the video, I will walk you through the VBA code needed to add picture comments in Excel 2010. The code has changed from what we used to use in Excel 2003, so it's important to pay attention to the changes. I will also show you how to use the macro recorder to help with the code. Unfortunately, due to the changes in Excel 2010, the code is a bit longer and more complex than it used to be. But don't worry, I will break it down step by step so you can easily follow along.
I want to give a special thanks to Andrew for sending in a question about this topic. It's always great to hear from viewers and help them with their Excel questions. So, if you have any questions or suggestions for future episodes, please don't hesitate to reach out. And as always, thank you for tuning in to the MrExcel podcast. Make sure to subscribe and hit the notification bell so you don't miss any of our future episodes. See you next time!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) VBA Picture Comments
(00:12) Background on VBA Picture Comments
(00:22) Steps to Add Picture Comments
(01:21) VBA Code for Excel 2010
(02:26) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
This video answers these common search terms:
how to add pop up image excel
how to add pop up message excel
how to add a pop up picture in excel
excel how to make a pop up image
how to make a picture pop up in excel
excel pop-up image on cell hover
hover-over image in excel tutorial
add picture on mouseover in excel
cell hover pop-up image excel
insert image on hover in excel cell
excel mouseover picture display
hover-triggered image popup excel
create pop-up image in excel on hover
cell tooltip with image excel
mouse hover action to show image in excel
I showed this a long time ago on an episode of TechTV. The VBA code that I used in Excel 2003 to add the pop-up pictures no longer works in Excel 2010. Today, with Episode #1386, Bill shows us how to update the code for use in Microsoft Excel 2010.
Смотрите видео Excel - Adding a Pop-Up Picture to an Excel cell using VBA - Episode 1386 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MrExcel.com 19 Апрель 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,903 раз и оно понравилось 17 людям.