How To Create 4 Different Dynamic Pop-up Comments In Excel Including A Chart

🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZbin MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create 4 different dynamic pop-up comments.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/PopUpComment_Wb
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:36 - Overview
6:01 - Selection Change Event
9:23 - Select Picture Icon
10:27 - Add Picture Icon
12:01 - Show Picture as Comment
17:03 - Create Dynamic Comment
21:54 - Create Formatted Comment
37:07 - Create Comment Chart Picture
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #dynamicpopupcomments #popupcomments #excelvba

[@ExcelForFreelancers]

🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

[@DrJohnPollard]

Randy is the man. He keeps coming up with out of the box manifestations in excel. Don't know how he does it!

[@ExcelForFreelancers]

Thanks so much Dr. John. I really do appreciate that.

[@Up4Excel]

This video is so packed with value it's untrue. Exporting a temp chart to create a picture is a genius idea on its own. There's so many ways this stuff could be used I shall definitely be making videos involving some of these ideas on my channel..... 👍😃📊💚

[@ExcelForFreelancers]

Thank you so much. I am super glad you liked it. I had not seen the chart in a comment before, so I wanted to share this feature. Much appreciated.

[@Up4Excel]

@@ExcelForFreelancers It's an excellent idea. Using dynamic pictures in comments like this opens up numerous options.

[@myfriendscallmeturk7568]

Your content is so great...with 25 years of experience you still are able to show me something new. I also appreciate your attention to design and user experience, great work and thanks for sharing!

[@ExcelForFreelancers]

Thanks so much Turk, I am really glad you enjoyed this training and found it valuable.

[@DedManWarKing]

Hi Randy, once again a great piece of training. Looking forward to adapting some of my spreadsheets with this functionality. Thank you for your efforts.

[@ExcelForFreelancers]

Hi Colin, thank you so much. I am glad you enjoyed it.

[@nerenlakhraj5252]

Hi Randy ... and yet another awesome tutorial with dynamic pop-up comments. Very unique ... thank you for sharing your creativity and brilliant ideas. Your are exceptionally talented

[@ExcelForFreelancers]

Thank you so much Neren. I always appreciate your feedback and thank you for being there for every training. Much appreciated.

[@SyedMuzammilMahasanShahi]

This is so beautiful. Thanks Randy for this unique effort.

[@ExcelForFreelancers]

For sure you are very welcome, as always, Syed

[@vladylaz6006]

Just suggestion. Use .Shape.TextFrame.AutoSize = True to auto resizing the comments. It's better then hard coded size. Good job and perfect tutorial. It's great pleasure to watch your videos!

[@ExcelForFreelancers]

Thanks so much. Really great suggestion. I do appreciate that. I may update the code and application with that.

[@joemanflyer2001]

Love the pop-up’s

[@ExcelForFreelancers]

Great, thanks so much Joe. I am glad to help

[@eddai84]

Hi Randy. As always, you did a good job.

[@ExcelForFreelancers]

Thank's so much. I am really glad you liked it.

[@grahamparker7729]

Excellent Randy 👍🏻

[@ExcelForFreelancers]

Thank you very much. I do appreciate that. Graham.

[@rohitgurung909]

Great!!!! Its amazing.....Thanks so much....

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Rohit

[@rakhisaxena4352]

Randy I have a question... Are you a wizard or a magician or something???? This takes my application to completely a different level. Thanks a million Tons!!

[@ExcelForFreelancers]

Thank you so much Rakhi, I am so glad that you enjoyed it and that I can help.

[@gavinbroughton]

@2:16 Selection Change - P.S You could use in the VBA: SelRow = ActiveCell.Row instead of ("B4").Value to negate the need for using a cell value in the sheet. @6:00 Selection Change VBA @9:20 Show Picture Comment @16:33 Dynamic Comment (/Content) @21:00 Dynamic Formatted Comment

[@ExcelForFreelancers]

Thanks so much for your great suggestions and feedback. Much appreciated. I am adding a lot of those features in our School Manager series here: Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

[@medkari]

Thank you

[@ExcelForFreelancers]

For sure, you are very welcome

[@jeremytobel2675]

I am a complete newbie to VBA, using your online videos I have managed to make a few great designs for use in my organization and information sharing. I came across this video trying to just display a table that already lives in another sheet of my document. I am wanting to have that table pop up when a specific cell with a specific name is selected. Is this far more simple than what you have created here? The tables are updated on a regular basis so creating the picture the way you would work I believe but feel there would be a more simple approach to displaying an already named table. Am I far off base here? Again total newbie so your videos and advice have been amazing tools for me. Thank you.

[@ExcelForFreelancers]

HI and thanks, yes that is correct. To Display a table in a pop-up, it can be done relatively simply. Use the Camra tool to 'take a picture' of that table. Then copy and past that picture into your sheet and give it a name. Use VBA to hight that picture, however when a user selects a specific row, that picture is displayed. I hope this helps and thanks so much.

[@prabhatrawat4394]

Great content. Quick question about the pop up. In this video the pop value is getting picked from same row. But what if I want that value to be picked from different sheet? How can it do a lookup first to find the same ID and pull out the data?

[@ExcelForFreelancers]

Hi and thanks for your comment. If in the selected row, you have the Unique ID of the item in the other sheet, you can use the FInd command along with the named range to find the row on the other sheet such as ItemRow = ItemsDB.range("Item_ID").Find(ItemID,,xlvalues,xlwhole).Row This would return the row of the found Item ID on any sheet. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@benc.s.9805]

Hi. Super Video. Thank you. Is it possible to change dinamically the background color of a cell when a new comment has been added?

[@ExcelForFreelancers]

Hi I was not sure, but after seeing your comment I did some research and found a way to do this. You could add a UDF (User Defined Function) in a module in VBA such as: Function getComment(incell) As String ' aceepts a cell as input and returns its comments (if any) back as a string On Error Resume Next getComment = incell.Comment.Text End Function Then you can add a new conditional formatting formula as follows: =getComment(A1)"" And the Applies To As =$A$1:$Z$99 Then the format of the Conditional formatting to color the background Then, after a comment is added and a sheet is calculated, the background will be colored Make sure that in your formula begins with the same cell (relative - without the $) and the Applies to also begins with the same cell. This will work just fine. Thanks for the good question.

[@rofiqulislam7544]

Good video 💖💖💖

[@ExcelForFreelancers]

Thanks for the visit Rofiqul

[@1988wally]

Hi Randy, love this video and it was very savage the skills you use to make such dynamic board. I was trying to make my ouwn macro to open the pic folder but when i click in other cell on the same line it will open again and erase the content that are in the cell where the pic it has to show. Thoughts?

[@ExcelForFreelancers]

Hi David, Thanks for your comment and glad you liked the training.. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@Michael--Hubbard]

I love this one. I made one for work since my memory is failing. Is this on Patreon by chance?

[@ExcelForFreelancers]

Hi Michael, you can download this file using the links in the description under the word DOWNLOAD. I do not have an updated version of this on Patreon. I hope this helps and thanks.

[@williammasek828]

Hello Randy, This is awesome. How to I make the Customer List sort able as in A to Z. This way I could keep the clients in alphabetical order even if I add or delete some.

[@ExcelForFreelancers]

HI William you can create a macro to sort, and then on each delete or name change resort the list. I just did this i a recent School Manager training here: kzbin.info/www/bejne/eorOgJKtlLqXba8 I hope this helps and thanks so much.

[@chicharron2008]

First of all, that was amazing, great video! I am a total noob with vba, so what I am trying to do is a dynamic chart to pop up automatically when clicking on a specific cells on my current sheet (sheet1). For example, if I click on a cell B2, I want a dynamic chart to pop up from a chart I have created on sheet2, If I click on C2, it will pop up my chart on sheet3 and so on. Can this be done? Do you have a way of doing this? Thank you in advance for any answer. 🙂

[@ExcelForFreelancers]

Hi Miguel, thanks so much for your comment. I do not believe I have a specific training on that however you can create a chart and then use the camera tool over that chart to create and a name a picture. You can then show/hide this specific picture anywhere you want on any sheet. This picture will be a 'live picture' so that when the data (or chart) changes so does the picture. you can also create and then show/hide a chart in any specific location as well. I hope this helps and thanks so much.

[@mdsaiful6294]

Nice

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saiful

[@dandeman1148]

Nice video! On the unformatted comment you didn't add visible, but on the formatted one you added two visible .shape.fill.visible and .visible = true On the formatted one when you click on a cell in col G the formatted comment appears, but the only way to get rid of it is click on another cell in the worksheet selection range. Even I f you click on a cell outside of the range the comment is stil there. So was wondering do you need both of the visible options and what's the difference between the two

[@ExcelForFreelancers]

Hi and thanks Dan. I am glad you enjoyed the video. If you want the comment to be hidden on any selection change, you can add this code to the selection change even, something like If Shapes("ShapeName").visible = True then Shapes("ShapeName").visible = msoFalse You would place this before the other selection change so that the comment only appears when the correct cell is selected. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@dandeman1148]

Not sure what you mean with shape name as its a comment that appears. I actually added a line in worksheet selection change under the line else: Shapes("AddPicBtn").visible = msofalse, then added Range("G4:G200").clearcomments

[@ExcelForFreelancers]

Hi Dan if your solution did not work, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@ahmedelnobi7522]

Is there a way to show more than one comment in one cell, for example a comment with a picture, a comment with data, etc

[@ExcelForFreelancers]

Hi and thanks very much for your comment. There is only one comment per cell, however I would combine both your picture and data in a single comment/picture so that you can have both. I hope this helps and thanks so much.

[@czechyorker]

How about Pop-Up preview of an invoice that's in PDF format. Is it possible?

[@ExcelForFreelancers]

Hi you can take any picture and preview it. (nice idea) however it may take a lot of disk space. After you create an Invoice, you can have Excel save it as a picture (Just as I did in this training) and make sure you save it as a dynamic name such as "Inv-123" , then when you select a row on an invoice simply call up that picture. and place it into the comment just as I did in the video. (pdf format would not help as we need to pull up pictures, not pdf's) Thanks for the nice idea. I may consider it when adding the Invoice feature to my Accounting Application that will be created in the Mentorship Program launching soon.

[@OsamaFayek]

hi Randy ' it's so great in unprotected worksheet but when We try in protected sheet it gave an error " object variable or with block variable not set ". we need your help to solve that matter

[@ExcelForFreelancers]

Hi Osama, just change the locked cell to unlocked in properties. This way it will not cause a bug when protected. You must do this for all cells in which VBA will change. You can also use xlUserInterface only when protecting. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@900604025959]

hi, so i need to buy the workbook to learn this from start? because the dev mode seems very different here

[@ExcelForFreelancers]

Hi and thanks all versions of Excel come with the developers mode. You can download this file for free using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@900604025959]

I really hope to build a work book like this from scratch, this is great

[@dineshmcv1]

Hi, I'm following all your vedios and this vedio is really. I have question - I can see you have added chart object inside comment box, how to insert picture instead of chart object? Please advise

[@ExcelForFreelancers]

hi and thanks so much. I show you how to add pictures in comment boxes in this video: kzbin.info/www/bejne/a4fWmp2rbKmcpLs I hope this helps and thanks so much.

[@dineshmcv1]

Hi, thank u for ur reply. What I was about ask is, how to add table snapshot using camera option, and how to insert that table snapshot inside comment box? I followed your steps but it was showing error in "with activesheet.chartobjects.add..." this line. Pls help. Thanks

[@ExcelForFreelancers]

Hi Dinesh, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@cbsubs]

Is there an issue or trick to get this working on a MacOS machine?

[@ExcelForFreelancers]

Hi and thanks very much. Mac's require different code because of their folder structure and also Macs are limited in what they can do since ActiveX components are not used on a Mac. There is more information on that here: www.macexcel.com/ I recommend you use Parallels which mimics the PC environment on a Mac so that you can use all of the features. www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.

[@richardhainsworth1200]

Hi Randy, I don't know if you're aware or not, but the link to download this via messenger is not working. There is an error report that opens when selected.

[@ExcelForFreelancers]

Thanks so much Richard. There was a space in the link, so i just fixed it. Very kind of you to bring my attention to that. Much appreciated.

[@kevindart5661]

Is there a way to make a pop up chart when I click on a name that shows info gathered from hidden cells or another sheet in a workbook? My wife is a teacher and she would like to see only 1 students fundraising info at a time.

[@ExcelForFreelancers]

Yes certainly, you can create a dynamic named range based on an advanced filter results, for a single student. You can then create a charge based on the results of this advanced filter, create a picture from it, then that picture can be displayed on the selection of a name. I hope this helps and thanks so much.

[@kevindart5661]

@@ExcelForFreelancers I am fairly new to Excel and do not have any VBA training. What would you recommend I do to learn how to do this?

[@ExcelForFreelancers]

Hi Kevin, the video that you commented on would be the closest training I have to that. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount

[@redhaakhund1271]

👍👍👍👍👍

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps Redha